diff options
| author | jasonmarlin <jason.marlin@gmail.com> | 2019-01-15 11:31:38 -0500 |
|---|---|---|
| committer | jasonmarlin <jason.marlin@gmail.com> | 2019-01-15 11:31:38 -0500 |
| commit | cffdc8efff9f0c66e6640a42fc375b4662b44180 (patch) | |
| tree | bc219294c4ba2dc207c04811fb1db91983f5dcf8 /phpBB/phpbb/help/controller | |
| parent | 5e302c7e15a2f683755eb500d162866484a898f6 (diff) | |
| download | forums-cffdc8efff9f0c66e6640a42fc375b4662b44180.tar forums-cffdc8efff9f0c66e6640a42fc375b4662b44180.tar.gz forums-cffdc8efff9f0c66e6640a42fc375b4662b44180.tar.bz2 forums-cffdc8efff9f0c66e6640a42fc375b4662b44180.tar.xz forums-cffdc8efff9f0c66e6640a42fc375b4662b44180.zip | |
[ticket/15941] Replace MAX to speed up query in update_post_information
Replace MAX SQL function with faster query using order by and limit.
The ajacent query could also be optimized to eliminate the usage of MAX.
Note that adding a compound key as suggested by EXPLAIN SQL yields an
improvement, but not nearly as fast as ORDER + LIMIT.
PHPBB3-15941
Diffstat (limited to 'phpBB/phpbb/help/controller')
0 files changed, 0 insertions, 0 deletions