Topic: Announcement: Another Speed Increase (Read 5418 times)

ClubCalibra · « **on:** February 25, 2009, 23:11:33 PM »

Things should really be flying tonight, I have made an adjustment to the way in which the forum renders Avatars, previously each avatar shown consisted of a number of Database queries - no more! Now they're loaded on the fly without any DB interaction.

In addition, I have up'd the number of posts/topics shown per page - the less you're clicking/paginating, the less load on the server - in a sense, more is less....or something like that!

Hopefully you'll notice the speed increase.

Cheers, @sh & Moderation Team
http://www.ClubCalibra.com

DrZux · « **Reply #1 on:** February 25, 2009, 23:16:27 PM »

All sounds good to me Ash, Site seems much faster.

Cheers

gorytus · « **Reply #2 on:** February 25, 2009, 23:23:51 PM »

Quote

the less you're clicking/paginating, the less load on the server

By doing so you have actually increased the read/writes io and/or private network throughput if the database is on a seperate server (highly recommended...); these are the two biggest bottlenecks on a sorted server setup. ( Tis why Google et al have a default 10 results on search results - not just for the extra ad revenue)

Ensuring all primary keys and indexes are in place, no table scans, up to date connection strings and trimmed 'noise' word list could be a worthwhile exercise if the database is proving to be a performance killer.

carl · « **Reply #3 on:** February 25, 2009, 23:30:59 PM »

lol i was going to come on this thread and say i wouldn't worry about the speed any more but this page took 30 seconds to load up....mind i think it may have something to do with my new isp? even though its ment to be 20 mb

ClubCalibra · « **Reply #4 on:** February 25, 2009, 23:56:27 PM »

Quote from: garyb on February 25, 2009, 23:23:51 PM

By doing so you have actually increased the read/writes io and/or private network throughput if the database is on a seperate server (highly recommended...); these are the two biggest bottlenecks on a sorted server setup. ( Tis why Google et al have a default 10 results on search results - not just for the extra ad revenue)

Ensuring all primary keys and indexes are in place, no table scans, up to date connection strings and trimmed 'noise' word list could be a worthwhile exercise if the database is proving to be a performance killer.

The general concensus on a busy forum like this is for there to be approximately 15 posts/topics shown per display - its the most efficient tested setup. Yes the DB is of course on a separate server, it'd be server suicide otherwise!!!

gorytus · « **Reply #5 on:** February 26, 2009, 00:34:41 AM »

Quote from: ClubCalibra on February 25, 2009, 23:56:27 PM

The general concensus on a busy forum like this is for there to be approximately 15 posts/topics shown per display - its the most efficient tested setup. Yes the DB is of course on a separate server, it'd be server suicide otherwise!!!

On a forum with this level of concurrent user sessions, changing item display amounts on such a narrow scale really shouldn't effect performance but the fact remains you are still increasing the database io, connection open time and local network throughput. As an example, one of our sites has an average 100 plus concurrents continually searching a 6 million record database, using scripted ASP rather than compiled pages, with no probs whatsoever - they have a default 50 items a page displaying (hw -2.3 twin xeons, 4gbram, sata10k drives).

Just thought it was worth flagging up as you mentioned server tweaking although as you are no doubt aware, simple server profiling should highlight the 'hotspots' from the serverside.

smiley55 · « **Reply #6 on:** February 26, 2009, 09:17:03 AM »

Thanks for the update! Er don`t do pc stuff so happy to drive the car, it`s easier =)

Richie86 · « **Reply #7 on:** February 26, 2009, 09:23:35 AM »

Quote from: garyb on February 26, 2009, 00:34:41 AM

On a forum with this level of concurrent user sessions, changing item display amounts on such a narrow scale really shouldn't effect performance but the fact remains you are still increasing the database io, connection open time and local network throughput. As an example, one of our sites has an average 100 plus concurrents continually searching a 6 million record database, using scripted ASP rather than compiled pages, with no probs whatsoever - they have a default 50 items a page displaying (hw -2.3 twin xeons, 4gbram, sata10k drives).

Just thought it was worth flagging up as you mentioned server tweaking although as you are no doubt aware, simple server profiling should highlight the 'hotspots' from the serverside.

^^^ Yeah thats what i thought

Garyb is actually a computer nerd

... who'd of thought

ClubCalibra · « **Reply #8 on:** February 26, 2009, 12:16:57 PM »

How are you guys finding the speed/performance today?

Richie86 · « **Reply #9 on:** February 26, 2009, 12:17:53 PM »

no problems to report here

JB · « **Reply #10 on:** February 26, 2009, 12:18:58 PM »

I've had numerous "document contains no data" errors,
But speed isn't too bad.

J A M E S · « **Reply #11 on:** February 26, 2009, 12:24:42 PM »

Speed seems fine today

gorytus · « **Reply #12 on:** February 26, 2009, 12:47:58 PM »

Quote from: Richie86 on February 26, 2009, 09:23:35 AM

Garyb is actually a computer nerd ... who'd of thought

!
I was a bearded wizard with a large stick of a c#ck yesterday or something like that; the difference a day makes....

JB · « **Reply #13 on:** February 26, 2009, 13:06:15 PM »

Gary, they're one and the same!

Quote from: Baytonator on February 26, 2009, 12:18:58 PM

I've had numerous "document contains no data" errors,
But speed isn't too bad.

I take that back, timeouts every other click for the last 30 or so mins now.

gorytus · « **Reply #14 on:** February 26, 2009, 13:22:37 PM »

Last 30 minutes I have had a continual stream of 500 Internal Server error pages. Which is handy as your webserver logfiles should be able to pinpoint the root cause. I assume they are monitored; it would be server suicide not too....

Quote from: Baytonator on February 26, 2009, 13:06:15 PM

Gary, they're one and the same!

Hobgoblins i've been rumbled.

ClubCalibra · « **Reply #15 on:** February 26, 2009, 13:28:37 PM »

Quote from: garyb on February 26, 2009, 13:22:37 PM

Last 30 minutes I have had a continual stream of 500 Internal Server error pages. Which is handy as your webserver logfiles should be able to pinpoint the root cause. I assume they are monitored; it would be server suicide not too....
Hobgoblins i've been rumbled.

Its the PHP Memory usage exceeding the allocated quota - I'm working on it...

JB · « **Reply #16 on:** February 26, 2009, 13:38:43 PM »

There's a distinct father-son atmosphere brewing between you and Gary, Ash.

"Nawh son, come on there lad. Error fahv 'undreds all deh long"
"I 'ma gon' fix it pawh"

Is it just me?

Ash - haven't been kicked out for a bit now.

ClubCalibra · « **Reply #17 on:** February 26, 2009, 14:15:43 PM »

Quote from: Baytonator on February 26, 2009, 13:38:43 PM

Is it just me?

Yep, you're wierd, hehe

I'm getting so frustrated in trying to find alternative PHP hosts that don't set a ridiculously low PHP Memory Limit whilst also delivering fast page delivery!!

carl · « **Reply #18 on:** February 26, 2009, 14:52:53 PM »

its running fine for me now

smiley55 · « **Reply #19 on:** February 26, 2009, 19:28:25 PM »

I only had about 1 hour of trouble then its been fine here thank you very much sir! Till I just tried to post and error blast

Author Topic: Announcement: Another Speed Increase (Read 5418 times)

DrZux

gorytus

gorytus

gorytus

gorytus