08-06-2013, 12:51 PM
Lately for almost years BBHF was using the thanks to unlock button and it was been quite useful from members to encourage more to share. But as our members and traffic spontaneously grow. We see huge impact of database queries EVERY SECONDS that causes our server to crawl slowly as hell despite of the fact that our server is on a dedicated server already in which I purchased a lifetime plugin of $1,500 USD to improve the speed and loading issue but still no matter where server we moved the issue still remains the same.
Yes, I am much more aware of the big issues that causing our server to act so slow and it was because of the thanks ajax request. Imagining hitting a database request of 1000+ per seconds on thanks ajax request alone that took 30 to 60 seconds to be processed.
(30 x 1000 = 30,000 minimum of db request per second, 60 x 1000 = 60,000 maximum of db request per second)
(In a minute, our forum are hitting --> 30,000 x 60 = 1.8m minimum db request, 60 x 60,000 3.6m db request on maximum state)
Now i am planning to do a one week test where in, I will remove the thanks to unlock button.
And replace it with post to unlock which was been done before, it was annoying and also consume much db query
(Contributors, Reviewers and VIP members are exempted to post to unlock )
Anyway, It will be one week of test. I will start the official date of one-week-test of server speed test with the changes that i am going to implement but before that i would love to hear some feedback first. Thanks.
Please participate on the vote. Thanks.
Yes, I am much more aware of the big issues that causing our server to act so slow and it was because of the thanks ajax request. Imagining hitting a database request of 1000+ per seconds on thanks ajax request alone that took 30 to 60 seconds to be processed.
(30 x 1000 = 30,000 minimum of db request per second, 60 x 1000 = 60,000 maximum of db request per second)
(In a minute, our forum are hitting --> 30,000 x 60 = 1.8m minimum db request, 60 x 60,000 3.6m db request on maximum state)
Now i am planning to do a one week test where in, I will remove the thanks to unlock button.
And replace it with post to unlock which was been done before, it was annoying and also consume much db query
(Contributors, Reviewers and VIP members are exempted to post to unlock )
Anyway, It will be one week of test. I will start the official date of one-week-test of server speed test with the changes that i am going to implement but before that i would love to hear some feedback first. Thanks.
Please participate on the vote. Thanks.