Improved eval monitor sql queries

Review Request #24 - Created Nov. 14, 2008 and discarded - Latest diff uploaded

Information
Valentin Stanciu
infoarena
Reviewers
hackers
Optimized monitor queries when there are are only filters related to `ia_job` table.
Did this by doing a simple query on the job table with filters and limits and then joining it with the other tables. This is a major improvement, as mysql will parse all entities in a table until it reaches the limits when there are left joins.
Going to last page of the eval monitor led to parsing the whole table, even if it's indexed or there's a limit in the query
We should test this with combinations of queries with limits and filters related only to job table or any table.
I only did tests to check if it works correctly, some statistics with improvements would be nice.
Loading...