Speed Racer Posted April 8, 2008 Posted April 8, 2008 See my post here:http://forums.invisionpower.com/index.php?showtopic=271473 I posted code there on what the issue was and how to fix. That is in the customer only area since I posted code and I am pretty sure that is not allowed in this particular forum.
Speed Racer Posted April 9, 2008 Posted April 9, 2008 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.