Kristen, I added the close to the function that opens.
Open - run whatever query was supplied -- close ---- get to processing.
That's why I'm concerned/confused it hasn't made a big difference.
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Kristen, I added the close to the function that opens.
Open - run whatever query was supplied -- close ---- get to processing.
That's why I'm concerned/confused it hasn't made a big difference.
Well, I emailed Steven to mention the change to the quote generator and asked him to let me know how much of a difference it makes over the next few days. I mean, if we were at say 150 connections, we should drop to 75 now.
Also, I agree it's worrisome. On the other hand, I can't see how we had 100 people posting at once, much less the same moment.
Shot in the dark. Do user sessions open connections to the database, or is that just strictly cookies and/or session variables?
Here's my last xpost:
Why not move ALL closed threads off this board? Leave them up for ONE WEEK, no more than that. Then we put the in "The Attic."
We could have them hosted by Fangeek, at a pretty minimal price (I know da owners, I'll haggle). That should lighten the "click through" load on the server, substantially. The threads would be available for read only, just not on this board.
They don't have to be here.
Speaking of the archives, are the subdomains working yet so that I can get to the archives ftp? And if so, what address do I use?
They are working again. If the FTP account is already set up, you should be able to login through ftp.buffistas.org.
DX, you should be good with the old address -- holler if not.
They are working again.
They are? Fangeek rocks!
Assuming that the biggest trouble really is just that we occasionally have 100 people all calling the database at the same time--is there any way to limit that on our end, directly? Hit 50 open connections, and all subsequent attempts have to wait 5 seconds and check again? Or it is impossible to divorce the attempt from the actual connection? Or would such a solution be, in its own way, as (or more) taxing?
(It's been too long since I was actually studying this stuff.)
DX, if you want to email me how you're doing the archive stuff, I can take some of it on tomorrow, probably get a couple of threads done.