Per Vognsen wrote: > Am I wrong to think that joining on docid should be as fast as joining on > indexed integer columns in other tables?
Looking up a record by docid is faster than non-FTS lookups on other columns, but the virtual table implementation still has to go through a separate query to look up the data in the actual table. > what's the recommended way to speed things up? If you want to do anything but FTS searches, you should store a copy of the data in a 'real' table. (If you're concerned about space, make the FTS table an external content table: <http://www.sqlite.org/fts3.html#section_6_2>.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users