On Aug 31, 2009, at 11:07 AM, Kalle Last wrote: > 2009/8/31 D. Richard Hipp <d...@hwaci.com>: >> >> On Aug 31, 2009, at 10:28 AM, Kalle Last wrote: >> >>> Hello, >>> >>> I'm having a big performance problem while trying to use sqlite as a >>> data output for my application. >> >> Before going further, have you seen http://www.sqlite.org/faq.html#q19 >> ? >> >> > > Weird, I tried it couple of days ago but it didn't help then. I > executed a simple "PRAGMA synchronous=OFF" right after creating the > tables. Now I removed the comments around that part and it made things > work quite good. I'm quite sure I haven't changed things from other > places. Oh well, at least it seems to be usable now. Only problem is > there seems to be 1-2s freeze on the moment I create a new file.
A CREATE TABLE statement is like an INSERT in that it modifies the database within a transaction. So if you have 10 tables, that is 10 transactions. Try doing the PRAGMA synchronous=OFF before you do the CREATE TABLE statements. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
