diff options
author | Dan McGee <dan@archlinux.org> | 2013-01-20 14:59:30 -0600 |
---|---|---|
committer | Dan McGee <dan@archlinux.org> | 2013-01-20 15:01:13 -0600 |
commit | 1b1b516bd823d807ea81e62fe14fc92c18d0b89d (patch) | |
tree | dc5360125caaa5a7a483a750b3e678012f4d757d /main/migrations/0036_auto__chg_field_userprofile_user.py | |
parent | dd8e94f69783365160bcbfda61a9bebea5a71324 (diff) |
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/0036_auto__chg_field_userprofile_user.py')
0 files changed, 0 insertions, 0 deletions