I am struggling with performance when using a class that calls itself in order to generate a navigation list. It's actually the secondary navigation used in a sidebar, and by using it, it adds about 5 or 6 seconds to the page load.
I'm hoping someone can help me with the design for this as the current way I am doing it is clearly not efficient.
Here is how it's done now.
The data is stored in 1 table, and the columns we're interested here are:
ID
MenuName
ParentID
1
Home
0
2
About Us
0
3
Our Company
2
4
Careers
2
5
Current Opportunities
4
6
How to Apply
4
7
Contact Us
2
< ...
Go to the complete details ...