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