Re: [sqlite] Slowness with FTS Queries and non-FTS tables

2013-05-08 Thread Scott Robison
On Tue, May 7, 2013 at 1:53 PM, Dan Kennedy wrote: > > Another way to go is to use the 'merge=X,Y' and 'automerge=0' commands: > > > http://www.sqlite.org/fts3.**html#mergecmd > > I tried a few variations on merging and automerging, and they did help t

Re: [sqlite] Slowness with FTS Queries and non-FTS tables

2013-05-07 Thread Dan Kennedy
On 05/08/2013 01:54 AM, Scott Robison wrote: On Tue, 30 Apr 2013 23:56:35 -0700 (PDT) Paul Vercellotti wrote: We've got some trouble with FTS4 queries taking too long in which we're looking for a subset of matching records in the FTS table, as narrowed by a non-FTS table. {details snipped} I'

Re: [sqlite] Slowness with FTS Queries and non-FTS tables

2013-05-07 Thread Scott Robison
On Tue, 30 Apr 2013 23:56:35 -0700 (PDT) Paul Vercellotti wrote: > We've got some trouble with FTS4 queries taking too long in which > we're looking for a subset of matching records in the FTS table, as > narrowed by a non-FTS table. > {details snipped} I've recently had to work through a simila

Re: [sqlite] Slowness with FTS Queries and non-FTS tables

2013-05-01 Thread Dan Kennedy
On Tue, 30 Apr 2013 23:56:35 -0700 (PDT) Paul Vercellotti wrote: > > > > Hi All, > > We've got some trouble with FTS4 queries taking too long in which > we're looking for a subset of matching records in the FTS table, as > narrowed by a non-FTS table. > > CREATE TABLE metadata( key AS INTEGE

[sqlite] Slowness with FTS Queries and non-FTS tables

2013-04-30 Thread Paul Vercellotti
Hi All, We've got some trouble with FTS4 queries taking too long in which we're looking for a subset of matching records in the FTS table, as narrowed by a non-FTS table. CREATE TABLE metadata( key AS INTEGER PRIMARY KEY, sectionID AS INTEGER ); CREATE INDEX sectionIdx on metadata(sectionID)