FWIW, I notice the window title on the CVSTrac-generated pages at sqlite.org is "Sqlite CVSTrace". I'm guessing it should be "SQLite CVSTrac".
----- Original Message ---- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: [email protected] Sent: 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 40000 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 like. > > "SELECT AlbumId ,Album FROM ALBUM ORDER BY Album LIMIT 100 OFFSET 0;" > > So for the next time I will change the offset to 200 then 300 ... > But the search Speed is fast initially and slows down later since it has > 40000 records. http://www.sqlite.org/cvstrac/wiki?ScrollingCursor -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
