Re: [sqlite] temp tables and PRAGMA temp_store
Hi Olaf, Aaah, that is a funny one! Will test today then with PRAGMA temp_store = FILE and see if that makes it slower! Bart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Olaf Schmidt Sent: 30 April 2008 04:24 To: sqlite-users@sqlite.org Subject: Re: [sqlite] temp tables and PRAGMA temp_store 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] temp tables and PRAGMA temp_store
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
[sqlite] temp tables and PRAGMA temp_store
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
