I ended up going with an external content table, and now everything works like a charm with the expected level of performance.
Thanks for the help! -Per On Thu, Oct 3, 2013 at 6:46 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
