Large Wiki Structure Performance Issues
When accessing the tiki-edit_structure.php page for my structure it loads fairly quickly but then the page becomes unresponsive for 30 seconds. I have attempted to optimize my Apache/PHP/MySQL as much as I can but nothing I do seems to help. I have enabled slow logging in MySQL and the log file is populated with 19000 lines every time the tiki-edit_structure.php page is loaded. I have around 650 wiki pages in the structure.
Is there anyway that I can optimize the loading of that page or alter the query so that it doesn't take so long to execute?