Re: [sqlite] SQLite with single writer on Windows network share

Many thanks for all your comments and suggestions. I will bear it all in mind. On Sun, 12 May 2019 at 12:26, Warren Young wrote: > On May 11, 2019, at 5:52 PM, Jose Isaias Cabrera > wrote: > > > > Warren Young, on Saturday, May 11, 2019 06:20 PM, wrote... > >> > >> On May 11, 2019, at 4:10 PM,

[sqlite] SQLite with single writer on Windows network share

Hi, We are currently backed into a corner by a customer and are looking at using an SQLite database hosted on a windows network share (using server 2012 R2 or later). We are well aware this is not advisable and have read https://www.sqlite.org/whentouse.html. My question is, if we limit the appli

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

I am now totally convinced that FTS3/4 does not work for this usage model. If you are deleting and inserting documents, the size of the FTS index will grow in a linear manner with no limit no matter what you do with the merge command (when you run it, what parameters you provide). I have separated

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

On 2 May 2014 10:22, Dan Kennedy wrote: > > > A query like: > > SELECT level, count(*) AS ntree FROM yourftstablename_segdir; > > will tell you how many b-trees there currently are at each level. Which > might help you figure out what is going on and when you might expect > a merge to actually s

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

On 2 May 2014 07:57, Dan Kennedy wrote: > On 05/01/2014 03:30 PM, andrewmo wrote: > >> 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