> 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

Reply via email to