|
 FreakShow
3n+hu$|@$+
Registered: 11/14/01
Posts: 439
Last seen: 22 years, 1 month
|
 Slow Forums   1
#465259 - 11/21/01 01:56 AM (23 years, 1 month ago) |
|
|
The forums seem to load especially slow when I'm logged in. Especially the main forum page. Sometimes it will take approx. a min to load the page. What's going on?
When I log out, the page loads in 2-3 seconds.
|
3DSHROOM
loon
Registered: 04/19/99
Posts: 2,878
Last seen: 11 years, 11 months
|
 Re: Slow Forums [Re: FreakShow] 1
#465407 - 11/21/01 08:24 AM (23 years, 1 month ago) |
|
|
When you are logged in it makes many queries to see if there are new posts in each forum since your last visit.
--------------------
Your friendly neighborhood loon
|
TranceTrippinXTC
Registered: 03/02/02
Posts: 185
Loc: Midwest
Last seen: 3 months, 20 hours
|
 Re: Slow Forums [Re: 3DSHROOM] 1
#569160 - 03/04/02 12:04 AM (22 years, 10 months ago) |
|
|
I've been hanging around the forums for a couple weeks now and just yesterday signed up. I've noticed that the forums, whether loading a post, or an index, logged in or not load really, really slow. The rest of the website loads at 50 KB/s When accessing any page in the forums it takes about 10 seconds before anything transmits, then only transmits at under 1 KB/s.
I was interested to find out where the server was located, did a WHOIS and saw the domain was registered in Calgary, Alberta, Canada by CIHOST. Then I did a tracert and saw the server is located in Bedford, TX. Not too far away from me, only 21 hops.
Anyway I'm sure it's not a bandwidth issue, maybe slow server or ineffcient code. I hate to bitch, I almost backed out of this post. But I noticed that it was slow whether I was logged in or not so I wanted to know what the problem is.
Either way, I will be using the forums every day. I can't thank you people enough and can only say keep up the good work.
BTW, once I find a new job I want to make a large donation. But for now I can only make a $25 donation when I get next week's unemployment check! It's cool you have it setup to make donations by Paypal. Cuz I'd be to lazy to write a check!
|
3DSHROOM
loon
Registered: 04/19/99
Posts: 2,878
Last seen: 11 years, 11 months
|
|
The bottleneck is in the server hardware, it just can't handle the load. This is why we are having a raffle to buy a new server.
--------------------
Your friendly neighborhood loon
|
TranceTrippinXTC
Registered: 03/02/02
Posts: 185
Loc: Midwest
Last seen: 3 months, 20 hours
|
 Re: Slow Forums [Re: 3DSHROOM] 1
#569575 - 03/04/02 12:01 PM (22 years, 10 months ago) |
|
|
Is the raffle still going? Cool, I'll buy some tickets and send a donation!
|
 Thor
Anti-Theist OVERLORD
Registered: 08/12/98
Posts: 10,017
Loc: Iceland
|
|
|
djfrog
omgws!!!1!
Registered: 10/22/00
Posts: 3,710
|
Re: Slow Forums [Re: Thor] 1
#570008 - 03/04/02 09:56 PM (22 years, 10 months ago) |
|
|
|
TranceTrippinXTC
Registered: 03/02/02
Posts: 185
Loc: Midwest
Last seen: 3 months, 20 hours
|
 Re: Slow Forums [Re: djfrog] 1
#571207 - 03/06/02 03:00 AM (22 years, 10 months ago) |
|
|
djfrog,
I read through that thread and I've come to think it's a little bit of both--inadequate hardware and inefficient code. But I would have to say that I like the script generated pages and I would agree with 3DShroom that the new server will help to load the generated pages about as fast as any other page. [What kind of box is it running on now though?] True, straight html would load faster, but I think the features of the scripted webpages outweigh the added extra speed of static pages.
Just my thoughts. Thx for posting that thread though. Was informative.
|
djfrog
omgws!!!1!
Registered: 10/22/00
Posts: 3,710
|
|
ok, as a little experiment.
The next time you are on during peak hours, log in go to the forums and measure how long it takes to generate that page. Then, log out and revisit the page. When you aren't logged in, it doesn't do nearly as much database access even though it is script generated. The difference is huge isn't it? If you have a fast connection you will see the difference most clearly.
However, I'm not just advocating this so that the forum list will load faster. Because of the architecture of the system, all the other script-generated pages would load faster.
Servers are multi-threaded to handle a large number of users simultaneously. Multi-threading allows big performance gains by allowing other threads to use the CPU when the active thread has to wait on a slow commands like a harddrive read or cache miss. However when multiple threads need to hit the same database table, they can only proceed one at a time to maintain that database's coherency. The faster harddrive will help decrease the time holding a lock per-thread, but removing the need to lock the database will prevent the lock altogether. Look at the harddrive specs its a 10x increase at the most. If you did the above experiment you'd realize the difference is orders of magnitudes greater than that 10x improvement.
Think of the separate threads as like lanes on a highway. Think of the database locks as exits from that highway. Increasing the processor speed is like adding more lanes, increasing the harddrive/memory speed is like increasing the efficiency of the exits.
The forum listing script is a drunk driver, crashing in from one exit, crossing every lane on the highway, and immediately exiting the next exit only to come back and do it again. Oh and there are a bunch of drunk drivers doing this. You think traffic is going to move?
I'm not saying we should do away with the scripted pages. They certainly help with listing the messages in a forum. I'm not saying a faster server wouldn't be nice either. I'm just saying the one script that is hitting every database is costing a lot for not much gain.
heh, ok, its late and I want to gripe and I apologize for that. But anyhow, if anyone is wondering why I'm not buying raffle tickets, the secret is out.
|
|
Threaded
Previous
Index
Next
Unfolding Nature: Being in the Implicate Order 
Red Vein Kratom 
Maeng Da Thai Kratom Leaf Powder
Edit 
Reply 
1 2 3 all )
tomk
kukusz
deviation13
World Spirit
Organic