We have a large Category Database 99000 Categories and the load times are unbearable. Is there any suggestions? Also it seem link IncludeInTopMenu loads all children regardless if the Children have the flag set? Am I missing something here?
1. I had tried the Fox MSSQLProvider Plugin and it didn't help. It's not DB or server resources as 99000 records isn't much.