Yes, I've been looking into using the prepare/bind/step functions instead. I'm at a complete loss as to what might have caused the behavior I initially saw, since every test I run now runs in constant time.
Thanks for the doc links Dennis, and thanks to everyone for their help and suggestions. Cheers, JP -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dennis Cote Sent: 19. júní 2009 04:43 To: General Discussion of SQLite Database Subject: Re: [sqlite] Database inserts gradually slowing down Jens Páll Hafsteinsson wrote: > Here's the code I'm using to run the test (it includes the schema). I've been > running this code for the last few days and am a bit baffled about my recent > results, since I'm not seeing the gradual slowing anymore. This happened > after I changed to use version 3.6.15 of sqlite and even if I change back to > 3.6.14 it still behaves very consistently, that is, doing the insert and > delete in constant time. > > Jens, I get similar constant time results using equivalent SQL scripts and the command line SQLite program. I noticed tat you are using the sqlite3_exec() API in your tests. If you are concerned about performance, as you seem to be based on the testing you are doing, you should look at switching to the preferred prepare/bind/step API functions (see http://www.sqlite.org/cintro.html and http://www.sqlite.org/cvstrac/wiki?p=SimpleCode for info and samples). Your test code is probably spending as much time compiling the same insert statement over and over again as it is on doing the actual inserts into the database. Using the alternate API you would prepare the statement once, then bind the values to be used for each insert, execute the insert, then reset the statement to be run again for the next insert. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
