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
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
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
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
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.
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
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.
7 matches
Mail list logo