Hi I suspect most of you know this, but since it helped me I decided to post it. I have around 5 million records in a sqlite file of about 400MB. Running joins over this was taking hours! And the disk went mental. Tweaking the following two pragmas solved the problem though. Hours to seconds!
PRAGMA temp_store = 2; PRAGMA cache_size = 100000; If this wasnt already so fast I would have just loaded the whole thing into a :memory: db. Regards _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
