On Mon, Dec 28, 2009 at 8:19 PM, Dan Kennedy <[email protected]> wrote: >> If you want the data for other purposes, you could almost implement a >> hack to get is. For instance, "SELECT count(docid) FROM fts_table >> WHERE fts_table MATCH 'x';" is kind of close, and you could change the >> match to handle prefix stuff. Unfortunately, the fts vtable cursor >> sets up a full table scan against the %_content table to satisfy >> fulltextColumn() requests. If the code could identify (or intuit) the >> case where you were just requesting the docid, then fulltextColumn() >> could return that directly from the index, which would be a LOT >> faster. > > FWIW, new versions do that. If you only read the docid/rowid column, > the %_content table is not used by an FTS3 query.
That's good to hear! Thanks, scott _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
