[banshee/stable-1.8] SaveTrackMetadataJob: Add LIMIT 1 to query

[Gabriel Burt <gburt src gnome org>]

commit 2b44d78157cc5c61b9f21d28c76028c355f79257
Author: Gabriel Burt <gabriel burt gmail com>
Date:   Tue Jan 4 15:22:49 2011 -0600

    SaveTrackMetadataJob: Add LIMIT 1 to query
    
    HyenaSqliteCommand reads in the entire result into memory in the form of
    a ArrayDataReader, so we should avoid asking for more rows than needed.

 .../Banshee.Metadata/SaveTrackMetadataJob.cs       |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/src/Core/Banshee.Services/Banshee.Metadata/SaveTrackMetadataJob.cs b/src/Core/Banshee.Services/Banshee.Metadata/SaveTrackMetadataJob.cs
index b367c45..fefe51d 100644
--- a/src/Core/Banshee.Services/Banshee.Metadata/SaveTrackMetadataJob.cs
+++ b/src/Core/Banshee.Services/Banshee.Metadata/SaveTrackMetadataJob.cs
@@ -68,7 +68,7 @@ namespace Banshee.Metadata
             CountCommand = new HyenaSqliteCommand (
                 "SELECT COUNT(*) FROM CoreTracks WHERE " + condition);
 
-            SelectCommand = DatabaseTrackInfo.Provider.CreateFetchCommand (condition);
+            SelectCommand = DatabaseTrackInfo.Provider.CreateFetchCommand (condition + " LIMIT 1");
         }
 
         public bool WriteMetadataEnabled { get; set; }