Re: [sqlite] FTS slowdown with matchinfo

2011-02-17 Thread Iker Arizmendi
Dan Kennedy wrote: > On 02/17/2011 05:41 AM, Iker Arizmendi wrote: >> Dan Kennedy wrote: >>> Can you make the database available for download? And >>> supply the exact query you are using too? I'd like to >>> know why this is. Thanks. >>> >>> Dan. >>> >> You can find a tarball of the DB file here:

Re: [sqlite] FTS slowdown with matchinfo

2011-02-17 Thread Dan Kennedy
On 02/17/2011 05:41 AM, Iker Arizmendi wrote: > Dan Kennedy wrote: >> >> Can you make the database available for download? And >> supply the exact query you are using too? I'd like to >> know why this is. Thanks. >> >> Dan. >> > > You can find a tarball of the DB file here: > >

Re: [sqlite] FTS slowdown with matchinfo

2011-02-16 Thread Iker Arizmendi
Dan Kennedy wrote: > > Can you make the database available for download? And > supply the exact query you are using too? I'd like to > know why this is. Thanks. > > Dan. > You can find a tarball of the DB file here: http://www.research.att.com/people/Arizmendi_Iker/geo.db.tgz This query

Re: [sqlite] FTS slowdown with matchinfo

2011-02-15 Thread Dan Kennedy
On 02/16/2011 12:50 AM, Iker Arizmendi wrote: > Hello all, > > I'm running into what seems like an abnormally large > performance drop on on some FTS queries that use > matchinfo when compared to those that don't. > > I created an FTS table using the following: > > CREATE VIRTUAL TABLE test >

[sqlite] FTS slowdown with matchinfo

2011-02-15 Thread Iker Arizmendi
Hello all, I'm running into what seems like an abnormally large performance drop on on some FTS queries that use matchinfo when compared to those that don't. I created an FTS table using the following: CREATE VIRTUAL TABLE test USING FTS4(rowid, content); and then filled it with ~2