[tracker/tracker-0.6] Attempt to speed up indexing by less cols in indices

[Martyn James Russell <mr src gnome org>]

commit a9e84a3ca3fb994496fe3af0459319d1803ea322
Author: Martyn Russell <martyn imendio com>
Date:   Wed May 20 17:26:11 2009 +0100

    Attempt to speed up indexing by less cols in indices
---
 data/db/sqlite-service.sql |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/data/db/sqlite-service.sql b/data/db/sqlite-service.sql
index 833cd8d..52e9cc9 100644
--- a/data/db/sqlite-service.sql
+++ b/data/db/sqlite-service.sql
@@ -81,7 +81,7 @@ CREATE TABLE  ServiceMetaData
 	MetaDataCollation	Text
 );
 
-CREATE INDEX ServiceMetaDataCompoundIndex ON ServiceMetaData (ServiceID, MetaDataID, MetaDataDisplay, MetaDataCollation);
+CREATE INDEX ServiceMetaDataCompoundIndex ON ServiceMetaData (ServiceID, MetaDataID);
 
 /* metadata for all keyword types - keywords are db indexed for fast searching - they are also not processed like other metadata. */
 CREATE TABLE  ServiceKeywordMetaData 
@@ -92,7 +92,7 @@ CREATE TABLE  ServiceKeywordMetaData
 	MetaDataValue		Text COLLATE NOCASE
 );
 
-CREATE INDEX ServiceKeywordMetaDataCompoundIndex ON ServiceKeywordMetaData (ServiceID, MetaDataID, MetaDataValue);
+CREATE INDEX ServiceKeywordMetaDataCompoundIndex ON ServiceKeywordMetaData (ServiceID, MetaDataID);
 
 /* metadata for all integer/date types */
 CREATE TABLE  ServiceNumericMetaData 
@@ -103,7 +103,7 @@ CREATE TABLE  ServiceNumericMetaData
 	MetaDataValue		Integer not null
 );
 
-CREATE INDEX ServiceNumericMetaDataCompoundIndex ON ServiceNumericMetaData (ServiceID, MetaDataID, MetaDataValue);
+CREATE INDEX ServiceNumericMetaDataCompoundIndex ON ServiceNumericMetaData (ServiceID, MetaDataID);
 
 
 CREATE TABLE DeletedServices