I was running some performance tests for both sqlite3 and sqlite4 and have a question about a difference in my numbers.
I'm running these on a Linux machine, so I enabled fdatasync for the sqlite3 build. I'm measuring the number of updates I can perform (updates per second), here are the numbers. sqlite3: Updates (CPU): 156250 Updates (Clock): 27733.6 sqlite4: Updates (CPU): 46729 Updates (Clock): 33132.8 With sqlite3 there's a large difference between the CPU time and wall clock time. No big deal, that's the I/O to disk. But then I'm wondering why the difference with sqlite4 is so small? For both tests pragmas synchronous=NORMAL, and journal_mode=WAL are set. Thanks, Rob _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users