Why not simply query all databases and merge the results in the application? I would think that would perform equally well, and the merging is likely straightforward to implement…
On Tue, Nov 8, 2016 at 1:32 PM Jan Berkel <j...@berkel.fr> 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. > > 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