branches/stable/extragear/multimedia/amarok/src

[Seb Ruiz]

SVN commit 678474 by seb:

Optimise: create additional indices as suggested by Gosta. I've tested with mysql, and confirm the speed increases.
Can users of sqlite and psql please test this as well, thanks.

BUG: 142999
CCMAIL: amarok at kde.org


 M  +8 -0      collectiondb.cpp  


--- branches/stable/extragear/multimedia/amarok/src/collectiondb.cpp #678473:678474
@@ -735,6 +735,14 @@
     query( "CREATE INDEX genre_idx ON genre( name );" );
     query( "CREATE INDEX year_idx ON year( name );" );
 
+    query( "CREATE INDEX tags_artist_index ON tags( artist );" );
+    query( "CREATE INDEX tags_album_index ON tags( album );" );
+    query( "CREATE INDEX tags_deviceid_index ON tags( deviceid ); ");
+    query( "CREATE INDEX tags_url_index ON tags( url(20) ); ");
+
+    query( "CREATE INDEX embed_deviceid_index ON embed( deviceid ); ");
+    query( "CREATE INDEX embed_url_index ON embed( url(20) ); "); 
+
     query( "CREATE INDEX related_artists_artist ON related_artists( artist );" );
 
     debug() << "Finished creating indices, stop ignoring errors" << endl;