On 12 Aug 2011, at 6:55pm, Yonnas Beyene wrote: > 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.
There are many differences between the ways the two systems work. For instance, SSE caches temporary indexes it makes up to answer queries. But SQLite gets far faster if you define suitable indexes for your queries because every query is considered separately. On the other hand, SQLite doesn't get much faster when you use multi-thread/multi-process code because access to the disk is a bottleneck, whereas in SSE the server process is the bottleneck. So you can make some minor changes to your database, like create an index or three, which will dramatically speed up SQLite. I recommend you read the SQLite documentation yourself, or put together a short description of any timing you find puzzlingly slow. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
