The following commit has been merged in the master branch:
commit 310ea3ff30f384b6e5b5f770429f8d415442d115
Author: Andreas Tille <[email protected]>
Date: Thu Mar 12 14:35:47 2015 +0100
Thanks to the hint of Akshita Jha <[email protected]> the bugs query can
be speeded up drastically!
diff --git a/misc/sql/bugs.sh b/misc/sql/bugs.sh
index c523fed..7b60363 100755
--- a/misc/sql/bugs.sh
+++ b/misc/sql/bugs.sh
@@ -19,7 +19,7 @@ psql udd > $1_buggy_packages.out <<EOT
FROM blends_dependencies bd
JOIN packages p ON p.package = bd.package
WHERE blend = '$1' AND bd.distribution = 'debian'
- GROUP BY p.package, p.source, bd.dependency, bd.component,
p.version
+ -- GROUP BY p.package, p.source, bd.dependency, bd.component,
p.version
) tmp
WHERE row_number = 1
) b
--
Static and dynamic websites for Debian Pure Blends
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
