Realcent.org

I've been getting this SQL lockout error more and more. Why is the server getting overloaded? Certainly, there are not that many users simultaneously making server requests. Could the periodic BOTs be maximizing system resources? I'd be interested to know if anyone has followed up on this persistent problem.

I just noticed the google bot was here,was curious too as how many users were here(20) after getting the error a few times.

This has already been posted several times and I am well aware of the problem.

There can only be 15 simultaneous connections to the forum database. This shouldn't be an issue, as most connections only last for a fraction of a second while posts are retrieved to generate a page. That means 15 people would have to load a page at the exact same time to cause a problem. Unfortunately some processes are taking much longer than they should. I thought I fixed the issue when I changed the way search terms are indexed to speed up searches (searches seemed to be the slowest process), and all seemed well for a couple days, but that obviously that wasn't the whole solution.

I am still analyzing the slow SQL processes to figure out what needs to be changed. There is also an update available for the forum software that I will be installing as soon as I can.

Thank you for your patience.

ThePowersThatBe wrote:This has already been posted several times and I am well aware of the problem.

There can only be 15 simultaneous connections to the forum database. This shouldn't be an issue, as most connections only last for a fraction of a second while posts are retrieved to generate a page. That means 15 people would have to load a page at the exact same time to cause a problem. Unfortunately some processes are taking much longer than they should. I thought I fixed the issue when I changed the way search terms are indexed to speed up searches (searches seemed to be the slowest process), and all seemed well for a couple days, but that obviously that wasn't the whole solution.

I am still analyzing the slow SQL processes to figure out what needs to be changed. There is also an update available for the forum software that I will be installing as soon as I can.

Thank you for your patience.

Hello TPTB:

Appreciate your hard work and dedication to keeping this site running smoothly. Just wanted to let you know that the above referenced error is happening quite frequently again. Today, several times AND I was the only member and zero guests in the topic I was wanting to navigate about. I would normally blame my slow dial-up; HOWEVER, it is also occuring on my cell phone (smart phone) when I try to view Realcent.

Thanks again for your assistance and I am bringing this up in case you had made the adjustments/updates thinking that stopped all problems.