I would like to know if someone knows what SQL in the procedures are execute when expanding a tree node in the left menu (my guess it is a type of GetChildren function which gets a list of page IDs and then fetches the pages one by one)? And what happens in the .net code (perhaps Episerver can help?) ?
We're having problems with our left tree menu in edit mode which is generally slow when loading the first time and when expanding a node. Episerver identified that this is because the way we've setup our website; many pagestypes with many properties (especially longstrings). We have about 40,000 pages. The tree is properly structured e.g. not many items under one node. Episerver already helped a lot with this by providing a left tree menu that does not read two levels deep every time a node is expanded, but the menu is still to slow for the client.
Because of the number of longsstrings I've added the following to the web.config:
<add key="EPnStringDelayedLoadThreshold" value="1" /><add key="EPnStringCompressionThreshold" value="500" />
But this does not seems to help improve the performance.
We're using Episerver 220.127.116.11 with Oracle.