Closing and opening again did not speed up steps 1-4, it actually slowed things down even more. The curve from the beginning is a bit similar to a slightly flattened log curve. When I closed the database and started the test again, a similar curve appeared again, but now starting from where the first run left off.
I've been running the same 3.6.15 since this afternoon (the previous test was using 3.6.14) and it seems to flatten out fairly quickly but it is significantly slower (2.3 to 1.3 times slower, depending on where you measure it using the data I have). I'm not that worried about that for the time being; I'm just hoping it will stay flat. JP -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: 16. júní 2009 13:30 To: General Discussion of SQLite Database Subject: Re: [sqlite] Database inserts gradually slowing down On 16 Jun 2009, at 1:06pm, Jens Páll Hafsteinsson wrote: > 1. start a transaction > > 2. insert 1000 records > > 3. commit > > 4. repeat steps 1-3 100 times > > 5. delete everything from the table > > 6. Start again at step 1 Okay, so do that until it's slow, then close the database and open it again, and do steps 1-4 once more. Is it still slow, or did closing and opening speed it up ? Simon. _______________________________________________ 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
