> -----Original Message----- > From: Richard Kuo [mailto:[EMAIL PROTECTED] > Sent: 16 June 2004 05:04 > To: [EMAIL PROTECTED] > Subject: [sqlite] SQLite performance with mid-size databases > > Hi. We are using SQLite to store and retrieve data rows where > each row is roughly 2K total in size and in a table of > 15 columns. The total size of the database ranges from 100-300 MB. > > The problem we are seeing is that query and insert performance is > unusually bad and scales up linearly with database size. Compared to > MS Access, the query times are several times slower.
Richard, I've done extensive comparision of SQLite vs Access and in general I'd say SQLite is faster. But you can't get meaningful results without being much more specific, and also testing where exactly the slowdown occurs. I'm sure there are some queries where Access can use indexes, but SQLite will scan the entire table or tables; obviously that's a huge perf. hit. With careful SQL tuning you can usually find a way around it. Access isn't a bad db engine either, as long as it's not used over a network :-) The main advantages of SQLite are that it is: - smaller - more customisable since you have the source - no dependencies to speak of, whereas Access needs MDAC etc. - cross-platform Tim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
