Hi,
Thankyou very much for the suggestions.
Best Regards,
A.Sreedhar.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 12:41 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]:Using sqlite3_progress_handler for GUI application
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Tue, Dec 18, 2007 at 02:10:02PM -0600, John Stanton wrote:
>
> > It won't be ignored. If you have an index ordered in the sequence
> > specified by the ORDER BY Sqlite will use that order instead of having
> > to assemble the result set and sor
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Tue, Dec 18, 2007 at 12:24:25PM +, Simon Davies wrote:
>
> > Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
>
> One question - using the example mentioned there:
>
> If we've created an index: CREATE INDEX example1 ON track
On Tue, Dec 18, 2007 at 12:24:25PM +, Simon Davies wrote:
> Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
One question - using the example mentioned there:
If we've created an index: CREATE INDEX example1 ON tracks(singer, title);
So, it'll make the query, like below, muc
If you store the last key and have an index on that key you will get
each 100 at the same speed by getting the first 100 greater than your
highest last key.
Sreedhar.a wrote:
Hi,
Say,I am having 4 entries in the table ALBUM.
"CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NULL,
nt: Tuesday, December 18, 2007 4:18:52 AM
Subject: Re: [sqlite]:Using sqlite3_progress_handler for GUI application
"Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Say,I am having 4 entries in the table ALBUM.
>
> "CREATE TABLE ALBUM (AlbumtId INTEGER PRIMAR
Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
On 18/12/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Say,I am having 4 entries in the table ALBUM.
> >
> > "CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NU
"Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Say,I am having 4 entries in the table ALBUM.
>
> "CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NULL,Album TEXT NOT
> NULL COLLATE NOCASE DEFAULT 'Unknown',UNIQUE(Album));"
>
> Now I want to list the first 100 Album from ALBUM table.
Hi,
Say,I am having 4 entries in the table ALBUM.
"CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NULL,Album TEXT NOT
NULL COLLATE NOCASE DEFAULT 'Unknown',UNIQUE(Album));"
Now I want to list the first 100 Album from ALBUM table.The result has to be
in sorting order.So my querry is
Hi,
Say,I am having 4 entries in the table ALBUM.
"CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NULL,Album TEXT NOT
NULL COLLATE NOCASE DEFAULT 'Unknown',UNIQUE(Album));"
Now I want to list the first 100 Album from ALBUM table.The result has to be
in sorting order.So my querry is
10 matches
Mail list logo