[gnome-music: 6/6] playlists: limit number of returned tracks to 50



commit 585000878f3f6c364b45be2cdf41f118d05989b2
Author: Vadim Rutkovsky <vrutkovs redhat com>
Date:   Mon Feb 16 14:17:26 2015 +0100

    playlists: limit number of returned tracks to 50
    
    This should protect us from file descriptors leak

 gnomemusic/query.py |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)
---
diff --git a/gnomemusic/query.py b/gnomemusic/query.py
index 4ee492c..992f26b 100644
--- a/gnomemusic/query.py
+++ b/gnomemusic/query.py
@@ -995,7 +995,7 @@ class Query():
                 nie:isStoredAs ?as .
             ?as nie:url ?url .
             FILTER ( NOT EXISTS { ?song nie:usageCounter ?count .} )
-        } ORDER BY nfo:fileLastAccessed(?song)
+        } ORDER BY nfo:fileLastAccessed(?song) LIMIT 50
         """.replace('\n', ' ').strip()
 
         return query
@@ -1018,7 +1018,7 @@ class Query():
                 ?as nie:url ?url .
                 FILTER ( ?last_played > '%(compare_date)s'^^xsd:dateTime )
                 FILTER ( EXISTS { ?song nie:usageCounter ?count .} )
-            } ORDER BY DESC(?last_played)
+            } ORDER BY DESC(?last_played) LIMIT 50
             """.replace('\n', ' ').strip() % {'compare_date': compare_date}
 
             return query
@@ -1039,7 +1039,7 @@ class Query():
                 tracker:added ?added .
             ?as nie:url ?url .
             FILTER ( ?added > '%(compare_date)s'^^xsd:dateTime )
-        } ORDER BY DESC(?added)
+        } ORDER BY DESC(?added) LIMIT 50
         """.replace('\n', ' ').strip() % {'compare_date': compare_date}
 
         return query


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