diff options
author | Yorhel <git@yorhel.nl> | 2009-11-15 11:09:34 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-11-15 11:14:06 +0100 |
commit | 06832f907632574ae41bf96e27e028b224078d39 (patch) | |
tree | c7d08887c0f05966fddf15548aeae48ada231680 /lib/VNDB/Plugin | |
parent | 7f1b892cb46c8f713a3bb7c5ea94de2f7aa42508 (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