[tracker/tracker-0.6] Fixes NB#125991, Image Viewer consuming more time to filter the images based on date.

[Mikael Ottela <mottela src gnome org>]

commit 7f9a0fbba6be5ce2f935fbd1ae6ce3cf76499ee3
Author: Mikael Ottela <mikael ottela ixonos com>
Date:   Thu Aug 13 13:49:55 2009 +0300

    Fixes NB#125991, Image Viewer consuming more time to filter the images based on date.
    
    Added an index to the numeric metadata for sorting. Together with the two previous patches this fixes some of the performance issues.

 data/db/sqlite-service.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/data/db/sqlite-service.sql b/data/db/sqlite-service.sql
index 52e9cc9..faa4e29 100644
--- a/data/db/sqlite-service.sql
+++ b/data/db/sqlite-service.sql
@@ -103,7 +103,7 @@ CREATE TABLE  ServiceNumericMetaData
 	MetaDataValue		Integer not null
 );
 
-CREATE INDEX ServiceNumericMetaDataCompoundIndex ON ServiceNumericMetaData (ServiceID, MetaDataID);
+CREATE INDEX ServiceNumericMetaDataCompoundIndex ON ServiceNumericMetaData (ServiceID, MetaDataID, MetaDataValue);
 
 
 CREATE TABLE DeletedServices