To render this page we are doing 433 jdbc queries on the databse (ouch)

277 queries on the project table (find by id - we have 277 projects)
156 queries on the nodeassociation table ( - we have 156 permission schemes...)

basically, the WW iterator is iterating over the schemes (loaded in one query)
And for each permission scheme, it is doing a query to find out what projects it has.
Then its doing a query per project to load its information....
Ouchy

This will undoubtedly also be the cause of JRA-7424 - and will affect all View XXX Schemes pages...

public List getProjects(GenericValue scheme) throws GenericEntityException
{
List projectIds = CoreFactory.getAssociationManager().getSourceIdsFromSink(scheme, "Project", getAssociationType());

// it is faster to go the project manager (which is presumably cached) than to load it via association manager
// if we every do database joins, then we may be able to remove this
List projects = new ArrayList();
for (Iterator iterator = projectIds.iterator(); iterator.hasNext()

Collections.sort(projects, OfBizComparators.NAME_COMPARATOR);
return projects;
}