Thanks Keith! I have spent several days trying to tune my query towards expected performance, without luck. I somehow missed your fairly straight forward solution. I still have some problems making sqlite use the correct indexes, but this can at least be fixed by well-placed INDEXED-BY-hints.
The declarative model of SQL is nice, but when you care about performance, it quickly gets frustrating and time consuming..I guess experience will help with this eventually. Fredrik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
