How can we improve the performance of a query to retrieve the list of collections in a project area?
I have created the following query to retrieve the lists of collections in a project area. :
The above query takes a lot of time for a project area with large set of collections. Many a times an IOException Connection reset is recieved. Is there any way to optimize the query to improve performance