We've got 40000 nodes in DB divided into 8 categories and managed by 2 groups. Although the cancel of ACL, OpenNMS makes always the same query which takes about 5 secondes (see attached file...). Is it possible to change the query or improve by other mean the hibernate performances ?
Sorry but this issue is resolved. It caused by a load of nodes + categories for each IHM navigation due to our IHM's changes. Now, we load only the categories when we change IHM view.
We've got 40000 nodes in DB divided into 8 categories and managed by 2 groups. Although the cancel of ACL, OpenNMS makes always the same query which takes about 5 secondes (see attached file...). Is it possible to change the query or improve by other mean the hibernate performances ?