Well, I am not an expert on this, but just want to touch some base things 1. Did you set indexes ? Sometime conversion tools didn't do that stuff properly. 2. Is Sql Server reside on same desktop or on LAN ? if it is on LAN probably the server machine is better and hence the comparison is irrelevant. 3. Sqlite in .NET as I see runs in same Memory as application where as Sql Server is obviously has its own process. Having said that if your application is not PARALLEL processing support, you might have little low response for obvious reason.
I don't think splitting DB is real good idea, but yeah they do make performance better. I would first try to optimize my query, make sure Datatypes are quite relevant to data, different database has different understanding on them. Hope those help. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Yonnas Beyene Sent: 12 August 2011 23:26 To: sqlite-users@sqlite.org Subject: [sqlite] Slow performance Hi, We are in the process of migrating our .NET desktop applications database from sql server express to sqlite (system.data.sqlite provider). As part of the task we converted one the large client databases to sqlite using an open source tool and tested some of the common queries. A simple "select * from table" query takes twice as longer time in sqlite compared to sql server express, Both use the same data structure and exactly the same code except for the connection and command objects. This specific table has just over a million rows and is related with lot of other tables. The total database size is about 450MB and 130 tables. My question is does reducing the number of rows (changing the db design) will help in any way or the query is a function of the total database size irrespective of number of rows in a table? Related with that is the performance of a simple direct query affected by the constraints it has in Sqlite? Is there any way we can optimize the performance? Thanks, I appreciate your input. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
