Re: [sqlite] FTS3/4 merge function behaviour when deleting rows

2014-05-13 Thread andrewmo
On 11 May 2014 00:01, Scott Robison-2 [via SQLite] < ml-node+s1065341n75608...@n5.nabble.com> wrote: > I suspect the primary use case it was designed and tested for (and in fact > the way we use it at my place of employment) was more for "only growing > datasets" and less for an environment where

[sqlite] FTS3/4 merge function behaviour when deleting rows

2014-05-01 Thread andrewmo
We are using the FTS3 extension to sqlite to store large numbers of short (~300 byte) documents. This is working very well and providing us with very fast text search, but the behaviour around deletion of documents has me confused. Our system must control the the size of the database and will dele