On 11/08/2016 07:32 PM, Jan Berkel wrote:
I use sqlite as an application specific format to distribute data to
mobile clients.
The data is generated and full-text indexed (FTS5) on the server, the
clients then
simply download one or more compressed db files.
Now I'd like to generate a full-text index for all downloaded files on
the client,
so items can be searched across all downloaded databases. I'd like to
avoid having
to re-index all databases since this would be slow, particularly on
low-end devices.
My idea would be to merge the existing indexes into a single combined
index which
can then be queried. This is an operation I expect to be reasonably
fast.
On the downside it would certainly require some custom code to perform
the
merge operation.
Before diving into the implementation I'd like to sanity check
this idea here first, maybe somebody has had similar problem.
I haven't actually tried anything like this, but it seems quite possible
if the databases all use distinct sets of rowids.
The best docs for the fts5 data format are the comments at the top of
source file "fts5_index.c".
Dan.
Thanks,
Jan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
