banshee r3679 - in trunk/banshee: . src/Core/Banshee.Services/Banshee.Collection.Database

[scottp svn gnome org]

Author: scottp
Date: Sat Apr  5 06:55:30 2008
New Revision: 3679
URL: http://svn.gnome.org/viewvc/banshee?rev=3679&view=rev

Log:
* src/Core/Banshee.Services/Banshee.Collection.Database/TrackListDatabaseModel.cs:
Minor SQL improvement when getting the count of items in an
unfiltered model.

Modified:
   trunk/banshee/ChangeLog
   trunk/banshee/src/Core/Banshee.Services/Banshee.Collection.Database/TrackListDatabaseModel.cs

Modified: trunk/banshee/src/Core/Banshee.Services/Banshee.Collection.Database/TrackListDatabaseModel.cs
==============================================================================
--- trunk/banshee/src/Core/Banshee.Services/Banshee.Collection.Database/TrackListDatabaseModel.cs	(original)
+++ trunk/banshee/src/Core/Banshee.Services/Banshee.Collection.Database/TrackListDatabaseModel.cs	Sat Apr  5 06:55:30 2008
@@ -185,7 +185,8 @@
         private void UpdateUnfilteredAggregates ()
         {
             HyenaSqliteCommand count_command = new HyenaSqliteCommand (String.Format (
-                "SELECT COUNT(*) {0}", UnfilteredQuery
+                "SELECT COUNT(*) FROM {0}{1} {2}{3}",
+                provider.From, JoinFragment, String.IsNullOrEmpty (Condition) ? String.Empty : "WHERE ", Condition
             ));
             count = connection.Query<long> (count_command);
         }