Cerulean Posted March 14, 2012 Share Posted March 14, 2012 Since I first started lurking and reading on this forum, I've been having SQL issues. I've tried browsing on Chrome as well as IE to see if that would resolve the issue, but it seems to be server-side.Clicking a link to another post will cause this issue, even clicking next page (or one of the numbers for a subsequent page) will sometimes prompt htis error.Also, attempting to search will randomly cause this issue. At times I can search and peruse just fine, other times it's a problem. I briefly scanned the Help forum to see if this topic was anywhere else - if I missed it and am double posting something already noted, I sincerely apologize.Servers can be a royal P.I.T.A. to maintain, and SQL isn't always the most entertaining endeavor - I know. Link to comment Share on other sites More sharing options...
Linda Posted March 14, 2012 Share Posted March 14, 2012 We're doing what we can in terms of turning off database-intensive functions, but unfortunately it isn't quite enough to eliminate all the errors as traffic is increasing when we approach the next season.We're not handling the server or the sql directly ourselves, so we're at the mercy of what we can do with the software itself to cut back on queries. There's a new version of IPB in beta that is supposed to have a lot better performance, so we hope we can upgrade before the show starts. Link to comment Share on other sites More sharing options...
Greywolf2375 Posted March 20, 2012 Share Posted March 20, 2012 I'm not techie at all, so the answer may be a resounding NO, but is there anything that we can do from our own connections that would help alleviate the issue? Any settings to change, not have multiple connections open (Smart phone & PC at the same time for example?), sacrifice a live chicken to the server gods? Link to comment Share on other sites More sharing options...
Xray the Enforcer Posted March 20, 2012 Share Posted March 20, 2012 Unfortunately, no. It's all down to the number of queries the database gets, and that's really down to the number of users who are on at a given point in time. This is why board performance is remarkably shittier once it gets into the work-day, Pacific Time, because everyone not in Asia is potentially attempting to connect to the board or wiki. Link to comment Share on other sites More sharing options...
RaceBannon42 Posted March 20, 2012 Share Posted March 20, 2012 I Blame Pod.The best solution is obviously to just shut down the book and TV show forums. No one important reads those anyway. Link to comment Share on other sites More sharing options...
Xray the Enforcer Posted March 20, 2012 Share Posted March 20, 2012 I Blame Pod.The best solution is obviously to just shut down the book and TV show forums. No one important reads those anyway.Done and done! ;) Link to comment Share on other sites More sharing options...
Ran Posted March 20, 2012 Share Posted March 20, 2012 And things may be a bit bad at the moment, as we're trying some things to try and eke out better DB performance. Sorry, folks, we really are working on stuff in the background! Just takes some time. Link to comment Share on other sites More sharing options...
Independent George Posted March 21, 2012 Share Posted March 21, 2012 Unfortunately, no. It's all down to the number of queries the database gets, and that's really down to the number of users who are on at a given point in time. This is why board performance is remarkably shittier once it gets into the work-day, Pacific Time, because everyone not in Asia is potentially attempting to connect to the board or wiki.Surely you don't mean to suggest that people are reading the boards when they're supposed to be working! What a shocking and scandalous accusation! Link to comment Share on other sites More sharing options...
7V3N Posted March 21, 2012 Share Posted March 21, 2012 Can you mass disable profiles and notifications? Would that help?Also, is there anyone for users to send donations toward getting these issues fixed? :bang: Link to comment Share on other sites More sharing options...
Linda Posted March 21, 2012 Share Posted March 21, 2012 The Shadow Fox,We do go into performance mode during the busier hours, which disables profiles and pms and search among other things, but sometimes its not enough.In terms of being able to move to a better server, its been in the works for a long time but unfortunately various complications have gotten in the way. Link to comment Share on other sites More sharing options...
Arristan the Old Posted March 21, 2012 Share Posted March 21, 2012 I'm not techie at all, so the answer may be a resounding NO, but is there anything that we can do from our own connections that would help alleviate the issue? Any settings to change, not have multiple connections open (Smart phone & PC at the same time for example?), sacrifice a live chicken to the server gods?When I get that SQL error (which says it's a problem at my end but I don't think that's true as it sounds like the same problem described above) I just keep hitting the refresh button until the page begins to load normally instead of repeating the error message. 95% of the time, that works every time. Link to comment Share on other sites More sharing options...
7V3N Posted March 21, 2012 Share Posted March 21, 2012 Yeah, I hit refresh too. But sometimes too many people are on and refresh doesn't solve anything.BTW, I got an SQL error getting to this page. :drunk: Link to comment Share on other sites More sharing options...
Res ipsa loquitur Posted March 21, 2012 Share Posted March 21, 2012 I was going to write a post on this myself. I keep getting the SQL error. What is it and what does it mean? I also refresh the page and generally it goes away. Link to comment Share on other sites More sharing options...
Independent George Posted March 21, 2012 Share Posted March 21, 2012 I don't wish to complain, but if server performance doesn't improve soon, I might actually have to concentrate on my work. I don't know if I can handle that. Link to comment Share on other sites More sharing options...
Linda Posted March 21, 2012 Share Posted March 21, 2012 I was going to write a post on this myself. I keep getting the SQL error. What is it and what does it mean? I also refresh the page and generally it goes away.The error means that as you tried to load the page, the SQL server was overloaded. It comes and goes, that's why a reload often fixes it. Link to comment Share on other sites More sharing options...
Res ipsa loquitur Posted March 21, 2012 Share Posted March 21, 2012 Hmmm...I should haveThe error means that as you tried to load the page, the SQL server was overloaded. It comes and goes, that's why a reload often fixes it.Hmm. I should have started more simply. What is a SQL server? Thanks, Linda. Link to comment Share on other sites More sharing options...
RaceBannon42 Posted March 21, 2012 Share Posted March 21, 2012 Hmmm...I should haveHmm. I should have started more simply. What is a SQL server? Thanks, Linda.http://lmgtfy.com/?q=what+is+an+sql+server Link to comment Share on other sites More sharing options...
Linda Posted March 21, 2012 Share Posted March 21, 2012 Hmmm...I should haveHmm. I should have started more simply. What is a SQL server? Thanks, Linda.Its part of the backend, the software that runs the forum. Basically, the computer that runs the board (and the wiki) occasionally cannot handle all the traffic because its all dynamic content served up from a database. So it has to access the database and search for information whenever someone loads a page. Link to comment Share on other sites More sharing options...
Frey Pie Posted March 22, 2012 Share Posted March 22, 2012 Sois the SQL server problem and me not being able to view my own profile and getting[#10245] You are not permitted to view member profiles.message related?Thanks Link to comment Share on other sites More sharing options...
Linda Posted March 22, 2012 Share Posted March 22, 2012 Yes, we turn off profiles to reduce the load on the server. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.