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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
