The Recent Verifications query is almost instantaneous under MySQL 5.5, but the production server is running 5.0 where it takes 3-5 seconds. We need to break up this query and see if it improves performance.
--- old+++ new@@ -1 +1 @@-The Recent Verifications query is almost instantaneous under MySQL 5.5, but the production server is running 5.1 where it takes 3-5 seconds. We need to break up that query and see if it improves performance.+The Recent Verifications query is almost instantaneous under MySQL 5.5, but the production server is running 5.0 where it takes 3-5 seconds. We need to break up this query and see if it improves performance.
status: open --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Implemented in biblio/recentver.py 1.4, installed in r2013-118 on 2013-09-24.
Diff:
Resolved by adding a new index to the verification table (by verification time) and breaking up the query into two. Closing.