Description of problem:
When AutoRecoveryManager runs it generates a query to select all VDS with a specific group name. This query is slow and can be optimized easily.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Connect with a profiler to engine, and examine queries.
Generated query is:
SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM vds_with_tags WHERE vds_with_tags.vds_group_name LIKE 'Default' )) ORDER BY vds_name ASC ,vds_name ASC ) as T1 OFFSET (1 -1) LIMIT 2147483647
Should be SELECT * FROM vds WHERE vds_group_name LIKE 'Default' ORDER BY vds_name ASC as T1 OFFSET (1 -1) LIMIT 2147483647
*** This bug has been marked as a duplicate of bug 984973 ***