On Fri, 26 Sep 2008 12:54:36 -0400, Russell wrote: >I need a 2 key index for some queries and also want to aggregate on >these 2 columns. I need this index BUT I have many large sqlite dbs I >iterate over and they won't fit in the filesystem cache. Run time when >the index is present is 105min. Run time with out the index is 3min.
Did you populate the sqlite_stat1 index statistics table with ANALYZE ? It might influence the query plan. >I see no way a simple query planner can account for factors like >available ram, disk io speeds and CPU speeds. The solution DRH >suggests is perfect for my needs. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
