Re: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-18 Thread drh
"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.

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-18 Thread Simon Davies
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

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-18 Thread Clark Christensen
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

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-18 Thread John Stanton
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,

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-18 Thread Zbigniew Baniewski
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

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-18 Thread drh
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

Re: [sqlite] :Using sqlite3_progress_handler for GUI application

2007-12-18 Thread drh
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

RE: [sqlite]:Using sqlite3_progress_handler for GUI application

2007-12-21 Thread Sreedhar.a
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