2011/10/12 Petite Abeille <petite.abei...@gmail.com> > > Now the join is performed only 250 times, adding just a small overhead > compare the the bare bone query without the join. > > The short of it: minimize the amount of work upfront :) > > Thank you very much! This approach solved the problem. However, in my situation I need to select a lot more columns than just 'id' from 'mail_header', and when I look at the resulting query it appears it is selecting all those columns twice.
Would it be smart to change the query so that the inner loop only selects mail_header.id, and adding a third join that fetches the extra columns from 'mail_header'? Or would the performance penalty from adding a third join out-weight the advantage of selecting less columns in the inner loop? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
