[banshee] SaveTrackMetadataJob: Add LIMIT 1 to query



commit 48c61319461a25a6ebecbbdd9456c9fd81214d8b
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; }



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]