Re: [sqlite] sqlite 3.6.5 slow on windows

Eric,   Thanks for the pragma tip which improves the speed significantly. The single insert is under 4 ms now.   The only published sqlite performance i found is http://www.sqlite.org/speed.html, which is too old. However, assuming the performance still holds up, the windows speed seems 10 times

[sqlite] sqlite 3.6.5 slow on windows

Hi,   I found sqlite is kind of slow on windows (2003 server and XP professional). Here is what i did: 1) downloaded and installed sqlite3.dll (version 3.6.5). 2) created a MSVC 6.0 C++ projects with the following code, which basically runs a list of SQL statments on a opened database:   #include