Re: [sqlite] speed for select statements

On Thu, 17 Apr 2008 12:47:52 +0530, Mahalakshmi.m wrote: >MY Table is: > >"CREATE TABLE ARTIST(ArtistId INTEGER PRIMARY KEY,ArtistName TEXT NOT NULL >COLLATE NOCASE, ArtistTrackCount INTEGER, UNIQUE(ArtistName));" > >"CREATE TABLE ALBUM(AlbumId INTEGER PRIMARY KEY,AlbumName TEXT NOT NULL

Re: [sqlite] speed for select statements

"Mahalakshmi.m" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am using > First 10 --> "SELECT * FROM ARTIST ORDER BY ArtistName LIMIT 10 ;" > Next 10 ie., 11 to 20 --> "SELECT * FROM ARTIST WHERE ArtistName > ? > ORDER BY ArtistName LIMIT 10 ;" > Previous 10 -->"SELECT * FROM

[sqlite] speed for select statements

MY Table is: "CREATE TABLE ARTIST(ArtistId INTEGER PRIMARY KEY,ArtistName TEXT NOT NULL COLLATE NOCASE, ArtistTrackCount INTEGER, UNIQUE(ArtistName));" "CREATE TABLE ALBUM(AlbumId INTEGER PRIMARY KEY,AlbumName TEXT NOT NULL COLLATE NOCASE,AlbumTrackCount INTEGER,UNIQUE(AlbumName));"