On 14 Jul 2010, at 4:17pm, Igor Sereda wrote: > For example, where we now have a query > > SELECT ...lots-of-joins... WHERE ...lots-of-exprs... AND someColumn IN > (?,?,?,? ...40 params... )
This -- the 'lots-of-joins' and the '40 params' in particular -- suggests you should be rethinking your schema. You'll probably speed up your entire system and save a lot of very complicated programming by merging some tables and/or making some separate columns of a table into a collection of keyed properties. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
