Oh-oh...

Jon

New Member
I think me and Spot broke the ShoutBox due to our sudden influx of shouts... :(

Sorry peeps :(
 

fury

Administrator
Staff member
I did that, while trying to optimize the queries there. I merged usernames into the shoutbox table so it wouldn't have to join the shoutbox table and the user table every time it was accessed (number of shouts per page * number of users, then add for the leaderboard, number of leaders * number of users... that's how many calculations MySQL had to do every time the shoutbox was accessed)
 

Dave

Well-Known Member
*phew*

glad it wasn't us. don't have enough money left after x-mas shopping to pay for a new shout box...

:D
 
Top