[banshee] SaveTrackMetadataJob: Add LIMIT 1 to query
- From: Gabriel Burt <gburt src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [banshee] SaveTrackMetadataJob: Add LIMIT 1 to query
- Date: Tue, 4 Jan 2011 21:26:02 +0000 (UTC)
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]