> it's sad that this simple select is not possible under sqlite3 :( This query is not so simple as you think, it requires pretty complicated advanced techniques to be executed differently than SQLite executes it. And even using those techniques you are not guaranteed to have good performance - it depends on data distribution in your table. To get an idea of how complicated technique should be try to think of your query in terms of phone book. So you have 6 phone books with the same data (million phones in total). 1st book has all data unsorted, 2nd has all data sorted by 1st letter (no tie-breaking sorting), 3rd - all data sorted by 2nd letter (no tie-breaking sorting) and so on. Now you want to find phones of all people whose name has first letter between d and i, second letter between t and v, third letter between f and k and so on. How would you search for these phones? It's pretty complicated stuff and wasn't included in SQLite because it's Lite.
Pavel On Fri, Dec 10, 2010 at 3:18 PM, Vander Clock Stephane <svandercl...@yahoo.fr> wrote: > not work :( > > it's sad that this simple select is not possible under sqlite3 :( > > > > On 12/10/2010 6:11 PM, Jim Morris wrote: >> Did you try a compound index? >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users