On 25 Feb 2005 at 10:33, Neelamegam Appadurai wrote: > But still, For the same application on windows, performance of sqlite > is slower compared to file system read or write which we were using > earlier.
Hurm I cannot think of anything obvious. I know from experience that SQLite is faster than a multi-file fake DB, faster than pretty much anything on the PC frankly How much data do you have in your DB? Over 6 million records or about 200 meg DB I noticed a slight reduction in speed but nothing to be worried about How many DB's do you have? Opening and closeing a SQLite DB isn't slow, but if you have a LOT of them it may be an issue What exactly are you doing that's slow? Runing a select statement on 2 million rows, returning 2,000 records should be under a 1/4 of a second (not talking test data or systems here, this is what we get in our program including display of said data) Are you doing Updates? We get about 8000 records a second Insert/Edit/Delete on a 2 million row DB. This is with transactions which are VITAL (But I'd think vital for Linux too) I don't really know much about Linux unfortunatly so can't really think of any differences that would account for a speed difference
