slow forum when theres a new vid
Moderator: Moderators
- Cloud_ax
- Hymn of One
- Posts: 26123
- Joined: Mon Jan 08, 2007 7:20 pm
- Location: stealing a plane to Zi's wedding, who wants to come??
slow forum when theres a new vid
the forum takes a hell of a long time to load when a new video comes out, and half the time i get kicked off the site. isnt there something that can be done about it?

I'm Ziola's Little Brother.
My big sister is getting married!!
"If this is a dream, don't wake me up."
-
- Enthusiastic Fan
- Posts: 252
- Joined: Sun May 27, 2007 7:17 pm
- Location: Nebraska
- Cloud_ax
- Hymn of One
- Posts: 26123
- Joined: Mon Jan 08, 2007 7:20 pm
- Location: stealing a plane to Zi's wedding, who wants to come??
yes, but can they do something about it? i hate it when a new video comes out and i either have to wait 5 minutes to get the forum to load or i get constantly kicked of the site. makes me what to hit someone with a mackerel. 


I'm Ziola's Little Brother.
My big sister is getting married!!
"If this is a dream, don't wake me up."
- Renegade
- Enthusiastic Fan
- Posts: 321
- Joined: Wed Jan 24, 2007 11:21 pm
- Location: Hamburg, Germany
- Contact:
The "standard" way to ensure fast loading at higher serving volume would be caching, however, there is no use caching a forum - the cached page would be outdated immediately, leading to thousands of visitors being served outdated pages. I guess that is the reason why nothing has been done so far.
What would be an option, imo, is making a "light" skin, with disabled quick reply, less images and stuff, that generally needs less database queries and bandwidth (in terms of kbs transfered) than the normal one. Such a skin would reduce the load on the SQL server and file system, as well as needing less bandwidth, since there'd be less images being served. That skin could then be set as forum default when a new video was uploaded, until the flood is over.
Since the default skin is probably a single database position (something akin to phpbb_config -> default_skin), it'd probably even be possible to automate it to mysql UPDATE whenever a certain load average is reached. (But I have no idea of such scripting, so I wouldn't know how.)
In addition, if it isn't enabled yet, HTTP compression could possibly be used to use the available bandwidth more efficiently.
What would be an option, imo, is making a "light" skin, with disabled quick reply, less images and stuff, that generally needs less database queries and bandwidth (in terms of kbs transfered) than the normal one. Such a skin would reduce the load on the SQL server and file system, as well as needing less bandwidth, since there'd be less images being served. That skin could then be set as forum default when a new video was uploaded, until the flood is over.
Since the default skin is probably a single database position (something akin to phpbb_config -> default_skin), it'd probably even be possible to automate it to mysql UPDATE whenever a certain load average is reached. (But I have no idea of such scripting, so I wouldn't know how.)
In addition, if it isn't enabled yet, HTTP compression could possibly be used to use the available bandwidth more efficiently.
- Cloud_ax
- Hymn of One
- Posts: 26123
- Joined: Mon Jan 08, 2007 7:20 pm
- Location: stealing a plane to Zi's wedding, who wants to come??
well another video and another night of slowness. im sorry to sound bitter, but this really gets under my skin.
i would just like to know if something is being done or is in the works to help correct the slowness (if something can be done at all) of the site when a new video comes out.
thank you for your time.
i would just like to know if something is being done or is in the works to help correct the slowness (if something can be done at all) of the site when a new video comes out.
thank you for your time.

I'm Ziola's Little Brother.
My big sister is getting married!!
"If this is a dream, don't wake me up."
- chershaytoute
- Moderator
- Posts: 1808
- Joined: Tue Jan 16, 2007 12:01 pm
- Location: Oregon with an ocean view...across the neighbors' cow pasture, wow!
- Contact:
No hitting with a mackerel, Cloud. I'm allergic... <rueful grin>Cloud_ax wrote:yes, but can they do something about it? i hate it when a new video comes out and i either have to wait 5 minutes to get the forum to load or i get constantly kicked of the site. makes me what to hit someone with a mackerel.

But in keeping with my taking lemons'n'making lemonade philosophy... There IS one plus side to this. It slows down the spambots at the same time it slows down the rest of us. Of course, I felt kinda like an old lady with a walker last night chasing around a 'bot with run-down batteries for a bit one night...it was hilarious. I'd get ahead, I'd get behind, I'd get ahead...but I finally ran 'em all down... <running around singing Rocky theme song...walker in the air in champion gesture>
Diane, or cher, or even chershaytoute, but "Hey, you!" works, too...
WWggD - let's make the Breeniverse a better place to live...
Thanks to giddeanx for the coolest personal glue stick ever!
WWggD - let's make the Breeniverse a better place to live...
Thanks to giddeanx for the coolest personal glue stick ever!