On Jun 3, 2008, at 7:27 PM, Christophe Leske wrote: > i am a new member of this list and interested in speeding up my > sqlite queries.
There are no magic bullets, but "The SQLite Query Optimizer Overview" is a good read: http://www.sqlite.org/optoverview.html As well as "Query Plans": http://www.sqlite.org/cvstrac/wiki?p=QueryPlans Once the basics are covered and you still need to speed up things, take a look at physically partitioning your data in several database files. This might reduce quite noticeably the overall processing time for a given query at the cost of a bit of added code complexity. -- PA. http://alt.textdrive.com/nanoki/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
