The following commit has been merged in the master branch:
commit 946965505dbb3e04f8b31566900ea2a38178d60f
Author: Andreas Tille <[email protected]>
Date: Fri Feb 5 17:52:29 2016 +0100
Speeding up by restricting the JOIN table to the interesting part
diff --git a/misc/sql/edam.sh b/misc/sql/edam.sh
index c73576e..eef98a4 100755
--- a/misc/sql/edam.sh
+++ b/misc/sql/edam.sh
@@ -63,6 +63,8 @@ $JSONBEGIN
) p
LEFT OUTER JOIN (
SELECT package, description, long_description, release, description_md5
FROM descriptions WHERE language = 'en'
+ AND package IN
+ (SELECT DISTINCT package FROM blends_dependencies WHERE
blend = 'debian-med' AND task IN ('bio', 'bio-dev'))
UNION
SELECT package, description, long_description, 'vcs' AS release,
description_md5 FROM blends_prospectivepackages
) en ON en.package = p.package AND (en.release = p.release OR p.release =
'vcs') AND (en.description_md5 = p.description_md5 OR en.description_md5 IS
NULL)
--
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
