summaryrefslogtreecommitdiff
path: root/lib/VNDB/Plugin
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-11-15 11:09:34 +0100
committerYorhel <git@yorhel.nl>2009-11-15 11:14:06 +0100
commit06832f907632574ae41bf96e27e028b224078d39 (patch)
treec7d08887c0f05966fddf15548aeae48ada231680 /lib/VNDB/Plugin
parent7f1b892cb46c8f713a3bb7c5ea94de2f7aa42508 (diff)
SQL: Improved performance of update_vnpopularity()
The previous statement was optimized for PostgreSQL 8.3 and took only about a second, but after the update to 8.4 it took about 10 times longer due to a different execution plan being generated. This slightly reworded statement generates a more efficient plan on 8.4.
Diffstat (limited to 'lib/VNDB/Plugin')
0 files changed, 0 insertions, 0 deletions