Re: [sqlite] Optimizing list retrieval with a FTS3 table

2011-03-17 Thread Travis Orr
TYPE " INTEGER); "; Thanks again, Travis -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Scott Hess Sent: March-16-11 4:20 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Optimizing list retrieva

Re: [sqlite] Optimizing list retrieval with a FTS3 table

2011-03-16 Thread Scott Hess
On Wed, Mar 16, 2011 at 12:15 PM, Travis Orr wrote: > Can someone enlighten me about this. To me a lot of the details appear > to be hidden since my main SongTable is a FTS3 virtual table. You don't provide your schema, but based on your queries, I'll make unwarranted assumptions

Re: [sqlite] Optimizing list retrieval with a FTS3 table

2011-03-16 Thread Jim Wilcoxson
gt; > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Wilcoxson > Sent: March-16-11 12:51 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Optimizing list retrieval with a FTS3 table &g

Re: [sqlite] Optimizing list retrieval with a FTS3 table

2011-03-16 Thread Travis Orr
Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Wilcoxson Sent: March-16-11 12:51 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Optimizing list retrieval with a FTS3 table On Wed, Mar 16, 2011 at 3:15 PM, Travis Orr

Re: [sqlite] Optimizing list retrieval with a FTS3 table

2011-03-16 Thread Travis Orr
To: General Discussion of SQLite Database Subject: Re: [sqlite] Optimizing list retrieval with a FTS3 table On Wed, Mar 16, 2011 at 3:15 PM, Travis Orr <t...@ivl.com> wrote: > I am currently working on a project that requires retrieving a list of > all the rows from a FTS3 table.

Re: [sqlite] Optimizing list retrieval with a FTS3 table

2011-03-16 Thread Jim Wilcoxson
On Wed, Mar 16, 2011 at 3:15 PM, Travis Orr wrote: > I am currently working on a project that requires retrieving a list of > all the rows from a FTS3 table. The ordering of the results varies by > search criteria. Since this is for an embedded project the list results > are passed

[sqlite] Optimizing list retrieval with a FTS3 table

2011-03-16 Thread Travis Orr
I am currently working on a project that requires retrieving a list of all the rows from a FTS3 table. The ordering of the results varies by search criteria. Since this is for an embedded project the list results are passed in chunks to another module to give the appearance of faster operations.