Just upgraded to VB 5.3.3 from VB4.
Things like latest activity and todays posts are fast, as is searching for anything.
Loading the home page is fast.
But going deeper into the forum is REALLY slow, as much as 15 seconds a page, on those channels with lots of posts. We've been using VB since about 2008 so some channels have over a million posts.
Non busy channels load in a couple of seconds.
I notice the same issue on this forum. The popular areas such as presales with 100k posts take 4-5 seconds to load, non busy such as suggestions is almost instant.
Looking at the process list with mysql I can't see any queries running during that 15 seconds and the slowest queries I see are about 3 seconds. Watching the slow query log whilst going into the large forums there are no slow queries shown.
So what is the VB code doing to take all that time. It only shows one page no matter if the channel is 100 posts or 1 million.
Things like latest activity and todays posts are fast, as is searching for anything.
Loading the home page is fast.
But going deeper into the forum is REALLY slow, as much as 15 seconds a page, on those channels with lots of posts. We've been using VB since about 2008 so some channels have over a million posts.
Non busy channels load in a couple of seconds.
I notice the same issue on this forum. The popular areas such as presales with 100k posts take 4-5 seconds to load, non busy such as suggestions is almost instant.
Looking at the process list with mysql I can't see any queries running during that 15 seconds and the slowest queries I see are about 3 seconds. Watching the slow query log whilst going into the large forums there are no slow queries shown.
So what is the VB code doing to take all that time. It only shows one page no matter if the channel is 100 posts or 1 million.
Comment