On 16 Jun 2009, at 4:31pm, Konrad J Hambrick wrote: > Is there a way to replace step 5 (delete everything from the table) > with a System-Level rm / unlink and a sqlite CREATE TABLE ?
JP can totally do that, but his original question was why the system gradually gets slower and slower. and that does indicate a bug somewhere, which should probably be identified. On 16 Jun 2009, at 2:52pm, Jens Páll Hafsteinsson wrote: > does sqlite use temporary files beside the database file? <http://www.sqlite.org/tempfiles.html> Might be interesting to have a look at those, with the application in a 'paused' state while it's taking a long time to do things, and see if any of them have got to be particularly big. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
