On 04/05/2010 12:22 PM, Alexey Pechnikov wrote: > Now virtual tables performance is bad in some useful situations. As example > this query produce full-scan of the FTS3 virtual table 'data':
I don't see what FTS3 has to do with your hash indices, nor do I see requirements to implement things the same way. In any event the virtual table API lets you provide your own implementation of functions. I'd recommend just going ahead and implementing a prototype using the virtual table API. That would at least allow you to substantiate any requests for a different/changed API. Roger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users