>Hi Rick.
>
>>SqLite is very dependent on proper configuration to get good performance out of it. Default config is pretty slow... but with turning off the transaction log (journal) and in memory usage it can do OK.
>
>Do you have an example of the configuration changes you make?
>
>Doug
Not offhand no. I ended up not using it, but it's easy to search for SqLite and performance.
The key is turn off journaling and use transactions effectively (ie. try to batch as much as you can into a single transaction for write operations).
There are 'Pragma' commands you can use as a Sql command to set these options.
Here's a good SO entry that talks about some of the things you can do:
http://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqliteFWIW, on my machine I only managed to get about 15,000 inserts a second with SqLite in any configuration I tried, but then this was with C# not C so that might account for extra overhead. I have an app that needs this kind of throughput too (
West Wind WebSurge Load Tester)
+++ Rick ---