Re: [sqlite] Merging FTS indexes

2016-11-12 Thread Jan Berkel
> 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… Yes I was thinking about that a well, just wanted to check if there was already some code for the merging

Re: [sqlite] Merging FTS indexes

2016-11-08 Thread Dan Kennedy
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

Re: [sqlite] Merging FTS indexes

2016-11-08 Thread Wout Mertens
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 wrote: > > I use sqlite as an application specific format

[sqlite] Merging FTS indexes

2016-11-08 Thread Jan Berkel
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