Wout Mertens wrote: > I assume I can use some sort of trigger setup to automatically update that > derived table when a row gets inserted, deleted or updated? Any pointers on > how to do that?
Something like this: http://www.sqlite.org/fts5.html#external_content_tables > Another approach I thought of is to assume I will only have a certain > number of array items (let's say 5), generate an "where is not null" > expression index for each of them, and then query them with 5 OR clauses. > Would that use more or less resources? Check with EXPLAIN QUERY PLAN whether the indexes are used at all. It's possible you'll have to use UNION instead. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
