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
