Hello to everyone.
I'm developing an app with Apex 5.1 and I had to create some pages with a tree region to represent hierarchical data. Every page contains only a tree region, and executes a hierarchical query from a table. With the smaller tables, the Apex page get loaded pretty fast (a bunch of second, nothing that a user can complain about). With the biggest tables (around 19k rows), the loading of the page becomes a problem, since it requires around 4-5 minutes, and the users started complaining. We did some tests and we were able to exclude network problems, installation problems and query slowness. The queries used executes on SQL Developer in 1-2 seconds, so we assumed it may just be too much data for that kind of region.
So the question we'd like to ask you is, are there any method to "pimp" the tree region performance in case of big data visualization, or are there any up-to-date lightweight "tree region"- like alternatives? Our searches brought us nothing.
Thank you very much,
Filippo