Clemens Ladisch schrieb am 20.02.2013 10:54:
GB wrote:
we are facing some Problems with Queries joining several FTS-Tables.
FTS tables cannot do efficient lookups except by docid or by MATCHing.
If you have to do joins with other tables, you typically set the docid
in the FTS table to some primary/foreign key in the other tables, and
then use the docids returned from some MATCH:
Yep, that's exactly what we are doing. But the regular Tables are not
causing any grief.
We already learned about fts4aux-Tables and are currently investigating
how we can make use of that info to create some better performing
statements. Any hints of course are greatly apprechiated.
Regards
Gerd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
