Using the latest SQLite and trying to speed up the making of some intermediate tables. I thought I could do that by doing PRAGMA temp_store = MEMORY and CREATE TEMP TABLE etc. I do run the PRAGMA directly after establishing the SQLite connection. So far I haven't seen any speed increase yet and I am wondering if maybe I am doing something wrong here. Does this PRAGMA only work on a newly created db file? Have tried that, but again no difference. Would you expect a speed increase from doing the above? I am running this from VB with the wrapper from Olaf Schmidt. Thanks for any advice.
RBS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
