diff options
| author | Dan McGee <dan@archlinux.org> | 2013-01-20 21:59:30 +0100 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2013-01-20 22:01:13 +0100 |
| commit | 1b1b516bd823d807ea81e62fe14fc92c18d0b89d (patch) | |
| tree | dc5360125caaa5a7a483a750b3e678012f4d757d /main/migrations/0013_mark_repos_testing.py | |
| parent | dd8e94f69783365160bcbfda61a9bebea5a71324 (diff) | |
| download | archweb-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 'main/migrations/0013_mark_repos_testing.py')
0 files changed, 0 insertions, 0 deletions