thanks for the long explanation pavel !
On 12/10/2010 11:50 PM, Pavel Ivanov wrote: >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users