IN( {inlist} ) syntax is not optimized, Alexey.
http://www.mail-archive.com/[email protected]/msg49985.html
Regards
Tim Romano
On Mon, Apr 5, 2010 at 3:22 PM, Alexey Pechnikov <[email protected]>wrote:
> Hello!
>
> On Monday 05 April 2010 22:22:40 Roger Binns wrote:
> > Virtual tables already let you implement indices in any way you want -
> see
> > the xBestIndex and xFilter methods. (The former is especially hard to
> > understand until you have worked with it a bit.)
>
> Now virtual tables performance is bad in some useful situations. As example
> this query produce full-scan of the FTS3 virtual table 'data':
> sqlite> select count(*) from data where rowid in (1);
> ^CError: interrupted
>
> After 30 minuts I cancel query... The test database is not too big - only
> about 60G size and less than 400M records ;-)
>
> And so select like to below are very slow:
> select ... from my_virtual_table where rowid in (...);
>
> Best regards, Alexey Pechnikov.
> http://pechnikov.tel/
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
