Since the last update the site seems to have got a lot slower, for me at least. Most other sites open as quickly as they ever did but Icrontic now takes a lot longer. Or is it just me?
I've made a lot of changes to the site tonight to improve performance. Please let me know if you still have significant lag.
Technical stuff:
Added garbage collection mentioned above
Latest News and Latest 3 Features are complicated to figure out. Now they only get figured out when a new main page post is made and get stored in a special table that's much faster to read from.
It look a long time for the database to sort the Hot Threads list because it was sorting ALL available threads. I've limited the search to the last 3 days worth of threads.
The Hot Threads plugin for the front page sidebar was using its own MySQL connection rather than piggy-backing on the existing connection. That has been fixed.
I'm currently working on a further enhancement that may slightly improve load time of the front page for logged-in members.
That's all the code optimization I could find to do; everything else is native to Wordpress or vBulletin which I trust is optimized beyond what I can do anyway. Anything else I do will be pulling levers and switches in MySQL which is... dangerous territory for me.
Comments
We're working on it
Technical stuff:
- Added garbage collection mentioned above
- Latest News and Latest 3 Features are complicated to figure out. Now they only get figured out when a new main page post is made and get stored in a special table that's much faster to read from.
- It look a long time for the database to sort the Hot Threads list because it was sorting ALL available threads. I've limited the search to the last 3 days worth of threads.
- The Hot Threads plugin for the front page sidebar was using its own MySQL connection rather than piggy-backing on the existing connection. That has been fixed.
I'm currently working on a further enhancement that may slightly improve load time of the front page for logged-in members.That's all the code optimization I could find to do; everything else is native to Wordpress or vBulletin which I trust is optimized beyond what I can do anyway. Anything else I do will be pulling levers and switches in MySQL which is... dangerous territory for me.