Michael Stephenson, We want to thank you again for your excellent suggestions
regarding how to improve the speed of our Sqlite WAL reads and our deduper
prototype. We looked at the SQlite documentation for increasing the Sqlite page
size to 4K and an excerpt of our code is shown below. If we can implement your
suggestions corrrectly, we try to let you and the sqlite-users group about our
results if they are meaningful. Thank you for taking the time to write all of
your suggestions and ideas.
strcpy(Command,"PRAGMA page_size=4096");
ReturnValue=sqlite3_prepare(Database,Command,-1,&Statement,0);
printf("1 ReturnValue %d\n",ReturnValue);
status = sqlite3_step(Statement);
printf("1 status %d\n",status);
status = sqlite3_finalize(Statement);
printf("1 status %d\n",status);
strcpy(Command,"VACUUM");
ReturnValue=sqlite3_exec(Database,Command,callback,0,&Msg);
if (Msg!=0) {
strcpy(LastError,Msg);
sqlite3_free(Msg);
}
printf("1-1 ReturnValue %d\n",ReturnValue);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
