Hi, I am having 40000 records and My table looks like ,
"CREATE TABLE ALBUMARTIST(AlbumArtistId INTEGER PRIMARY KEY NOT NULL,AlbumArtistName TEXT NOT NULL COLLATE NOCASE DEFAULT 'Unknown', UNIQUE(AlbumArtistName));" "CREATE TABLE ARTIST(ArtistId INTEGER PRIMARY KEY NOT NULL,ArtistName TEXT NOT NULL COLLATE NOCASE DEFAULT 'Unknown',UNIQUE(ArtistName));" "CREATE TABLE BGM(BgmId INTEGER PRIMARY KEY NOT NULL,BgmName TEXT NOT NULL COLLATE NOCASE DEFAULT 'Unknown',UNIQUE(BgmName));" "CREATE TABLE MUSIC(Id INTEGER PRIMARY KEY NOT NULL,Album TEXT NOT NULL COLLATE NOCASE DEFAULT 'Unknown',Track TEXT NOT NULL,URL TEXT NOT NULL,Artist_Id INTEGER,AlbumArtist_Id INTEGER,Bgm_Id INTEGER);" Where Artist_Id , AlbumArtist_Id , Bgm_Id are the type ids of table ALBUMARTIST,ARTIST,BGM,MUSIC . I will search for the following 1. SELECT * FROM ARTIST ORDER BY ArtistName; 2. SELECT * FROM ALBUMARTIST ORDER BY AlbumArtistName; 3. SELECT Track,URL FROM MUSIC ORDER BY Track ; 4. SELECT BgmId,BgmName FROM BGM ; 5. SELECT DISTINCT Album FROM MUSIC WHERE Artist_Id = ? ORDER BY Album ; 6. SELECT Track,URL FROM MUSIC WHERE Artist_Id = %s ORDER BY Track ; 7. SELECT Track,URL FROM MUSIC WHERE Artist_Id = ? and Album = ? ORDER BY Track; 8. SELECT Track,URL FROM MUSIC WHERE AlbumArtist_Id = '%s' ORDER BY Track; 9. SELECT Track,URL FROM MUSIC WHERE Bgm_Id = '%s' GROUP BY Track ; To achieve better performance do I want to index the tables ALBUMARTIST,ARTIST,BGM or its not needed. Will the performance increase by doing indexing the Artist_Id , Album in MUSIC table. Kindly suggests some ways. Thanks & Regards, Sreedhar.A ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
