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>
Tue, 22 Dec 2015 06:45:10 +0000 (01:45 -0500)
eda/drivers/sqlite/EDASQLite.ec

index a6b6fd0..14ecc62 100644 (file)
@@ -117,6 +117,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);