Information wont display correctly

[stuart dodds]

When trying to use the Shared System collection "All Management Processors", the information takes 8 or 9 min to be displayed, I have tried creating a query manually but same result, if however a search is done for a Management processor by name the information is returned correctly, The database is SQl hosted locally on the same server, there are 405 |Ribs in the System, The “All Servers” has the same number of entries, the information is returned within 5 seconds, Any Ideas will be welcomed with open arms!!!