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

Reply via email to