use transactions to make import faster

diff --git a/src/sql/schedulexmlparser.cpp b/src/sql/schedulexmlparser.cpp
index c1c65597a6fd3de94862d44955ff6b5e74a2b7c2..8ce0a6812850e47f7ae09dd15ee5946f19fee670 100644 (file)
--- a/src/sql/schedulexmlparser.cpp
+++ b/src/sql/schedulexmlparser.cpp
@@ -37,6 +37,8 @@ int ScheduleXmlParser::parseData(const QByteArray &aData)
 
     QDomElement scheduleElement = document.firstChildElement("schedule");
 
+    SqlEngine::beginTransaction();
+
     int confId = 0;
     if (!scheduleElement.isNull())
     {
@@ -144,6 +146,7 @@ int ScheduleXmlParser::parseData(const QByteArray &aData)
             } // parsing room elements
         } // parsing day elements
     } // schedule element
+    SqlEngine::commitTransaction();
 
     return confId;
 }

diff --git a/src/sql/sqlengine.cpp b/src/sql/sqlengine.cpp
index 90cb989acac948d0e84b98f63a4eebaea08d5feb..9c0150c113a51385679be2a34fcb8ef32d02075a 100644 (file)
--- a/src/sql/sqlengine.cpp
+++ b/src/sql/sqlengine.cpp
@@ -375,6 +375,20 @@ int SqlEngine::searchEvent(int aConferenceId, const QHash<QString,QString> &aCol
     return 1;
 }
 
+bool SqlEngine::beginTransaction()
+{
+    QSqlDatabase db = QSqlDatabase::database();
+
+    return execQuery(db, "BEGIN IMMEDIATE TRANSACTION");
+}
+
+bool SqlEngine::commitTransaction()
+{
+    QSqlDatabase db = QSqlDatabase::database();
+
+    return execQuery(db, "COMMIT");
+}
+
 bool SqlEngine::execQuery(QSqlDatabase &aDatabase, const QString &aQuery)
 {
     //qDebug() << "\nSQL: " << aQuery;

diff --git a/src/sql/sqlengine.h b/src/sql/sqlengine.h
index 68dd5b43c75eeab978e39c012fe3c22c748d7327..b6fb2885af73d7f4e25f32cc8e6c7d8831c75f55 100644 (file)
--- a/src/sql/sqlengine.h
+++ b/src/sql/sqlengine.h
@@ -37,6 +37,9 @@ class SqlEngine : public QObject
         static void addLinkToDB(QHash<QString,QString> &aLink);
         static void addRoomToDB(QHash<QString,QString> &aRoom);
 
+        static bool beginTransaction();
+        static bool commitTransaction();
+
         // search Events for ....
         static int searchEvent(int conferenceId, const QHash<QString,QString> &columns, const QString &keyword);
     private: