TexasCHLforum.com

speed seems back to normal

cudos

mojo84 wrote:Charles, In the other thread about the slow downs, it was mentioned how large this sites database has become and how preservation of the history is important. There may be a decent compromise and option that may help. I am not an forum expert so I may be barking up the wrong tree. I've noticed some forums seem to have an archive function. This allows the posts to be archived separate from the primary active database and even though new posts cannot be added, the old posts will still be available to search and view. You may have already considered this but I thought I would mention it just in case.

baldeagle wrote:I'm not sure why that would be necessary, mojo84. I maintain a board with 750,000 posts (over 1.1 million since inception but 300,000 have been pruned), and it's plenty responsive. I just rebuilt all 750,000 posts today in about an hour and a half after upgrading the server OS. Proper coding and database design will make a database of 1,000,000 posts quite responsive. You'd have to get into the tens of millions before responsiveness would become an issue. It just depends on the software.

Im also experiencing the site being slow. Click wait 3 or 4 seconds for anything. Im sure Charles and his team will get it straight.

I host multiple forums with a total of approx 5 million posts on a single modest server with many many other sites on it and they all run fine. The issue is the forum needs to be coded correctly and the number of queries per page needs to be reasonable. Make sure any attachments are stored in the file system and not the DB.
Most of these forums are running on LAMP with Mysql as the database, when you get to the millions of posts you HAVE to have FAST I/O which means FAST drives. There is no substitute.

In reading the closed slow thread - Vertbiz came across defensive. In looking at their website the "cart" doesn't appear to include SSD drives as an option.
Unlike Vertbiz Im a sole proprietor - no team - no one to share blame with - just many years of experience with enthusiast forums. And an interest and understanding that many people on the web move on if they have to wait more than a few seconds for your site.

Im not aware of forum software that lets you "archive" posts off to a separate database. Most of the time what you see as archive is simply OLD posts that dont get rendered when looking at new posts. They arent on a separate database.

Thanks for keeping the software current
As you likely know the board is slow - Likely due to the indexing going on
There aren't that many people on the board now so the slowness isnt likely due to that

If the migration changed the URLs or anything else related to search engines
you might consider changing your robots.txt file to exclude search spiders from the site for a few days will the internal indexing is updating .. The load from the 5 search engines currently spidering the site and the internal index rebuild may be too much for the server

My forums really benefit from disk speed, we started running SSD drives a few years back and the server load rarely goes over .3 now which means the sites are rendered very fast.

Good luck