eda/sqlite: Setting page size to 4096 to help performance on NTFS
authorJerome St-Louis <jerome@ecere.com>
Tue, 23 Sep 2014 20:33:49 +0000 (16:33 -0400)
committerJerome St-Louis <jerome@ecere.com>
Fri, 20 Feb 2015 15:39:11 +0000 (10:39 -0500)
eda/drivers/sqlite/EDASQLite.ec

index 19f9c1d..404c263 100644 (file)
@@ -144,6 +144,9 @@ class SQLiteDataSource : DirFilesDataSourceDriver
          {
             bool success = true;
             char command[1024];
+
+            sqlite3_exec(db, "PRAGMA page_size=4096;", null, null, null);
+
             sprintf(command, "CREATE TABLE eda_table_fields(Table_Name TEXT, Name TEXT, Type TEXT, Length INT);");
             sqlite3_exec(db, command, null, null, null);