Slow...

Avder · Post by **Avder** » Thu Mar 02, 2006 4:08 pm

Is it just me, or is the board rather slow lately? It seems like half the time when I try to post something, the board doesnt respond and I end up seeing \"waiting for www.descentbb.net\" in my browsers status bar forever? And I know its not me because every other board I use on the net is extremely responsive...so...yeah...

CDN_Merlin · Post by **CDN_Merlin** » Sun Mar 12, 2006 8:43 pm

Last 2 days when i click \"post since last visit\" I get a blank screen after 2 minutes of waiting.

Grendel · Post by **Grendel** » Sun Mar 12, 2006 11:00 pm

CDN_Merlin wrote:Last 2 days when i click "post since last visit" I get a blank screen after 2 minutes of waiting.

dito.

Floyd · Post by **Floyd** » Mon Mar 13, 2006 11:31 am

Richard Cranium · Post by **Richard Cranium** » Mon Mar 13, 2006 6:07 pm

CDN_Merlin wrote:Last 2 days when i click "post since last visit" I get a blank screen after 2 minutes of waiting.

Yep, I can reproduce it but it will take some time to fix. We will do what we can.

Grendel · Post by **Grendel** » Fri Mar 17, 2006 11:27 am

Was ok for a day or two (w/ the shield orbs missing at the end !), the blank screen is back since yesterday

MD-2389 · Post by **MD-2389** » Fri Mar 17, 2006 11:01 pm

I also found that if you search for something that will turn up a large ammount of results (like say the username \"kurupt\" in the NHB), you'll get a few whitescreens until it FINALLY churns up a search result.

Richard Cranium · Post by **Richard Cranium** » Sat Mar 18, 2006 9:55 am

Well, I have found a number of posts talking about other people having trouble with the search feature on other boards so at least we aren't alone.

Part (most) of the problem is the number of nested queries the search function creates. There are two parts to the search function.

1) Input... The first part creates the data and puts it in the search tables. This part works ok for new posts but breaks when it trys to rebuild the search tables.

2) Output... The second part is the search button the user can use to search the board. This part is slow to parse the PHP code in to a SQL command and the SQL command it creates is very inefficient.

When you get enough messages on the system with enough unique words in them the queries are too big for the query processor and it runs out of memory for either type of query. There is a mod someone is developing that might help but it will require some testing on our test site. Also the next major revision of PHPBB is also going to address this issue with a DB redesign.

RC

MD-2389 · Post by **MD-2389** » Sun Mar 19, 2006 1:23 pm

I also noticed last night on Teamspeak some extreme choppyness. I was chatting with Ferno and TigerRaptorFX when all of a sudden I'd hear only partial words. This is the only server I've had this kind of problem with, so I know its not my end. We went to another server not too long after it happened, and we never had a problem. This was around midnight CST or so. Was the server under some kind of heavy load?

Slow...

Slow...

Re:

Re: