RB Smissaert <[EMAIL PROTECTED]> writes: > > 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.
Hi Bart, the reason why you don't see any changes is, that this is already the default in my version of the SQLite-engine compile (sqlite35_engine.dll). ;-) Olaf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
