Re: [sqlite] Big performance problem with inserting lots of data

2009-08-31 Thread Kalle Last
2009/8/31 D. Richard Hipp : > > 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.s

[sqlite] Big performance problem with inserting lots of data

2009-08-31 Thread Kalle Last
se transactions by doing a pair of end/begin queries once per second but it didn't seem to change much. Data got saved just fine but it was still horribly slow. My best guess at the moment is that program hangs because of excessive file synchronization. Anyone has any better guesses what cou