On Mon, 18 Oct 2010 15:07:35 +0200, Hilmar Berger <hilmar.ber...@integromics.com> wrote:
> Hi, > >thanks to everybody that answered. I tried your suggestions but there >was no measurable improvement. Possibly this is the best what I can get >out of Sqlite. >However, I tried a similar query on a larger table using both SQlite and >Postgresql (same machine, same table structure + indices, same data). >Postrgresql took 25secs for this query while it took more than 1 hour >with SQlite. Obviously there is room for improvement. If I manage to >find out what makes the difference I will post it here. Did you already try to run ANALYZE; on the fully populated database? It gathers statistics about indexes and those are used by the optimizer to choose a query plan. It might not help in your case, but it doesn't hurt to try. >Thanks again and best regards, >Hilmar -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users