"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] -----------------------------------------------------------------------------
