admin at shuling.net wrote: > I am just curious whether there is a performance comparison between SQLite > and SQL Server?
That depends on the data, and the software, and the hardware. In other way: you have to measure yourself. > Surely SQL Server will perform better on huge database with thousands > of tables(more than 10GB size). If you write a query that needs to read all the data, both databases are limited by the I/O speed. Otherwise, the two databases will have similar performance, unless you're using a query that can use some optimization that is implemented only in one of them. SQLite uses a much simpler locking scheme that can be faster if there aren't concurrent accesses. SQL Server has higher concurrency. This is not necessarily dependent on the size of the database. Regards, Clemens
