Jump to content

Fix: Slow Portal Plugin (Last X Topics) Mysql Query

Guest Speed Racer

Recommended Posts

Update. This change reduced my loads from on average 3-5 to less than 0.1. That is an incredible drop. For those that use the IPB portal as their main page this is huge. The old query took 10 seconds to complete on average and the portal was being called about every two seconds so do that math and there were on average 5 10 second queries running at any given time doing a file_sort. That is really bad. The new code in my links above make my server scream and saves me a huge amount of $ from potential hardware upgrade costs.

I hope the IPB dev's see this and implement it.

If you do (@IPB) please post here.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...