Quoth Mathieu Schroeter <schroe...@epsitec.ch>, on 2010-10-20 15:41:51 +0200: > Thanks for your interesting answer. > > The first plan looks the best but it does not explain the ORDER BY. > If I could done this job with pencil and paper, my way will be: > > a) enumerate all entries in lol > b) for each entry look up a corresponding row in tmp using its > primary key > c) the loop over lol is complete, I see that tmp.data uses > `COLLATE foobar` then I look if an index exists. > d) Yes then I use idx_foobar instead of many calls on the > comparison function.
In step (d), you're doing what? Sorting the resulting rows? How exactly would you use the index for that? ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users