summaryrefslogtreecommitdiffstats
path: root/__init__.py
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2013-01-20 21:59:30 +0100
committerDan McGee <dan@archlinux.org>2013-01-20 22:01:13 +0100
commit1b1b516bd823d807ea81e62fe14fc92c18d0b89d (patch)
treedc5360125caaa5a7a483a750b3e678012f4d757d /__init__.py
parentdd8e94f69783365160bcbfda61a9bebea5a71324 (diff)
downloadarchweb-1b1b516bd823d807ea81e62fe14fc92c18d0b89d.tar.gz
archweb-1b1b516bd823d807ea81e62fe14fc92c18d0b89d.tar.xz
Query performance enhancements in get_requiredby()
For packages with particularly long lists of provides (e.g. perl), the query was getting a bit out of control with the list of names passed in. However, changing it to simply do a subquery resulted in some really poor planning by PostgreSQL. Doing this as a custom 'WHERE' clause utilizing the 'UNION ALL' SQL operator works very well. Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to '__init__.py')
0 files changed, 0 insertions, 0 deletions