Having a few issues with the load on the front page of my site. I know what is causing it. It is the modifications that I have loading on the main page such as birthdays, statuses, whos been online, top 24 posters etc etc. Basically just an overkill of front page items on my site.
Now I dont want to get rid of all these items my users enjoy on the main site, and therefore our thoughts are that some of these items need to be cached. At first thought running a cron job periodically for the given items to put them into new tables, so its litterally delete the old, and insert the new each time. This would mean I could simple do a select * from my table which would be extremely fast. This would seem a good way forward, and a direction I am willing to take.
However I know there are things that are cached around xenforo that use existing tables to cache data. Wondered if someone could give me their thoughts on this scenario, whether I am going the right way about it, or if not how I would go about it instead.