Hello, As an expoeriment I'd like to create various virtual tables (vtable) for SQLite. Like filysystem, process list, mailbox - all local or remote. The idea is to use SQLite as an unified API and query processor to access or join data from various sources. I read an old old article in Dr. Dobbs ( http://goo.gl/khg1pN), and it mentions an issue with OR conditions vs. virtual tables, that is if a query has theese, than the filter conditions will not be passed to the xBestIndex call, and thus will not be passed to xFilter, and thus access to the virtual table will always be done as table scan, and that is quite inefficient. Rewriting queries is not an option as the article suggest, as that would force users to an unusual SQL style just to make things faster. Are there any advancements in this topic? Any experiences with this issue? Or any suggestions for other query processing engines I might use?
Thanks, Andris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users