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. Creating ~10 empty tables shouldn't be all that complicated to slow things down that much. I'll try to some more analysis to see what's going on. Thanks for making me re-try disabling synchronizing and sorry for waisting everyones time/bandwidth :) -- Kalle Last _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
