914club.com BBS is slow, anyone else notice this? |
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
914club.com BBS is slow, anyone else notice this? |
siverson |
Aug 17 2004, 12:46 AM
Post
#1
|
Advanced Member Group: Benefactors Posts: 2,448 Joined: 5-May 03 From: San Diego, CA Member No.: 654 Region Association: Southern California |
I know this came up a few weeks ago, but was it ever resolved? The page load times seem to be getting slower and slower.
I can't imagine that you need a super high horsepower server or connection to run this site... Just playing armchair system admininstrator from the sidelines it seems some database tuning may be needed. I'd be happy to contribute to a fund for a faster server or some DB consultants time or... ? -Steve |
Martin Baker |
Aug 17 2004, 01:17 AM
Post
#2
|
I just heard I sold my cars! Group: Members Posts: 1,140 Joined: 11-February 03 Member No.: 290 Region Association: Northern California |
I have noticed it, seems to fly when there aren't so many user's on-line. Like now... (IMG:style_emoticons/default/stones.gif)
|
thesey914 |
Aug 17 2004, 02:48 AM
Post
#3
|
Senior Member Group: Benefactors Posts: 1,155 Joined: 1-January 03 From: Staffordshire -England Member No.: 66 |
yes. I've noticed -for the last 2/3 weeks
|
machina |
Aug 17 2004, 06:06 AM
Post
#4
|
Advanced Member Group: Benefactors Posts: 2,030 Joined: 21-June 03 From: Miami Beach, FL Member No.: 848 |
I notice it more after I have been to the shop talk forums, that place as really fast but that's probably because Jake runs it (I think).
dr |
JWest |
Aug 17 2004, 06:15 AM
Post
#5
|
Senior Member Group: Members Posts: 1,662 Joined: 6-January 03 From: Fort Worth, TX Member No.: 97 Region Association: None |
Yes, it has been noted and the admins say it not the site, but I have a routine of about 10 sites I check every morning. 914club always has big delays in loading the pages that I never experience at the other sites.
It is really annoying, and absolutely restricted to only this site. I often open another browser and surf another site while waiting for a page to come up. |
Part Pricer |
Aug 17 2004, 06:27 AM
Post
#6
|
Believe everything I post Group: Benefactors Posts: 1,825 Joined: 28-December 02 From: Danbury, CT Member No.: 35 |
(IMG:style_emoticons/default/agree.gif)
I load five different sites in tabs as my "homepage". The 914club is always the last to come up. I don't think that the problem is with bandwidth or server response. From my cursory investigation, those seem adequate. Has the database been optimized using the Invision mySQL Toolbox? (not trying to be a prick, just trying to help) |
anthony |
Aug 17 2004, 09:17 AM
Post
#7
|
2270 club Group: Benefactors Posts: 3,107 Joined: 1-February 03 From: SF Bay Area, CA Member No.: 218 |
I was seeing the slowness a few weeks ago but now it's pretty fast for me. Try a traceroute to www.914world.com and see what it turns up.
|
7391420 |
Aug 17 2004, 09:21 AM
Post
#8
|
Member Group: Members Posts: 353 Joined: 6-August 03 From: boston, ma Member No.: 988 |
I aint no computer wiz but, I regularally check from 3 different computers, all on high speed, all of which are new Pentium 4's and are very fast in general, but the 914 club site is always slow....
|
KenH |
Aug 17 2004, 09:39 AM
Post
#9
|
Senior Member Group: Members Posts: 680 Joined: 16-January 03 From: Gilroy, CA Member No.: 156 |
I just pushed the "back" button from this thread and it took 40 seconds to respond. Came back to this thread to make this post and it took 20 seconds load.
Ken |
Brad Roberts |
Aug 17 2004, 09:44 AM
Post
#10
|
914 Freak! Group: Members Posts: 19,148 Joined: 23-December 02 Member No.: 8 Region Association: None |
The page loads have been slow for me also (and I'm only 10hops or so from the server) I do think it is a database issue. Each page is generated.. The box appears to be fine and the connection is fine.
The MYSQL hasnt been touched as far as I know since it was configured and installed. B |
Joe Bob |
Aug 17 2004, 10:24 AM
Post
#11
|
Retired admin, banned a few times Group: Members Posts: 17,427 Joined: 24-December 02 From: Boulder CO Member No.: 5 Region Association: None |
One reason is that it reloads everytime you go back or click on a new page....most sites will not post the newest data when you hit BACK....this one does.
|
SirAndy |
Aug 17 2004, 03:03 PM
Post
#12
|
Resident German Group: Admin Posts: 41,676 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California |
QUOTE(Paul Heery @ Aug 17 2004, 05:27 AM) I don't think that the problem is with bandwidth does OC48 sound big enough? (IMG:style_emoticons/default/laugh.gif) our server connection goes literally straight into a *big* OC48-Pipe the size of my arm. i don't think we could saturate that pipe, even if we all tried at the same time ... i've been thinking about moving the site back onto one of my compaq boxes that has dual CPU, 4 Gig RAM, raid-array, blah blah. right now, the current box and the fairly large mySql DB could be a bottleneck. (IMG:style_emoticons/default/wink.gif) Andy |
BMartin914 |
Aug 17 2004, 03:08 PM
Post
#13
|
||| Group: Members Posts: 1,408 Joined: 30-May 04 From: Oregon Member No.: 2,128 Region Association: Pacific Northwest |
I am noticing the slowness too. This morning the 914 Tech BBS took so long I just gave up (and we are using T1 at my office).
With dial up at home the site seems fine, but some times it's incredibly slow with the T-1. Ben |
siverson |
Aug 17 2004, 03:17 PM
Post
#14
|
Advanced Member Group: Benefactors Posts: 2,448 Joined: 5-May 03 From: San Diego, CA Member No.: 654 Region Association: Southern California |
> i've been thinking about moving the site back onto one of my compaq boxes that has dual CPU, 4 Gig RAM, raid-array, blah blah. right now, the current box and the fairly large mySql DB could be a bottleneck.
Again, I really don't know what I'm talking about so I shouldn't be offering sys admin advice, but I doubt it's the hardware. Anything better than a P2 should run this site fine, it's probably how the db is configured. Might need an index on a table somewhere or something... I'd offer to have one of our guys at work look at it, but we're primarly a Microsoft shop, so we'd be fumbling around a lot. It's probably a 2 hour project for the person that knows what they are doing. -Steve |
mikester |
Aug 17 2004, 04:15 PM
Post
#15
|
Member Group: Members Posts: 326 Joined: 18-June 03 From: CA Member No.: 837 |
QUOTE(SirAndy @ Aug 17 2004, 01:03 PM) QUOTE(Paul Heery @ Aug 17 2004, 05:27 AM) I don't think that the problem is with bandwidth does OC48 sound big enough? (IMG:style_emoticons/default/laugh.gif) our server connection goes literally straight into a *big* OC48-Pipe the size of my arm. i don't think we could saturate that pipe, even if we all tried at the same time ... i've been thinking about moving the site back onto one of my compaq boxes that has dual CPU, 4 Gig RAM, raid-array, blah blah. right now, the current box and the fairly large mySql DB could be a bottleneck. (IMG:style_emoticons/default/wink.gif) Andy That fiber is actually less than a mm thick. :finger2: |
Brad Roberts |
Aug 17 2004, 04:43 PM
Post
#16
|
914 Freak! Group: Members Posts: 19,148 Joined: 23-December 02 Member No.: 8 Region Association: None |
I knew Andy was in trouble when he said that... I have stood next to OC48 and OC12 cabinets... the number of T1's splitting off that cabinet require a physical pipe the size of his arm...LOL
I used to do T1 card testing in those cabinets... B |
ematulac |
Aug 17 2004, 05:14 PM
Post
#17
|
914 addict Group: Members Posts: 540 Joined: 24-November 03 From: Palmdale, CA Member No.: 1,382 |
I've actually thought about this for a long time, and here's my educated guess:
It takes a long time for the BBS to calculate how many pages belong in a thread. That "Member 914 Pictures" thread now has about 80 pages. It has about 1600 replies and my guess is that everytime you load that forum or redisplay that page it's going to go and calculate how many pages it will take you to view all 1600 of them. On other BBS's they kill threads (make it so you can't post to them) and start a new one after they are so many pages long, and I'm guessing it's for this very reason. I've done a lot of work with database reporting and one of the biggest performance killers for a report is displaying "Page X of Y" in the footer, since it has retrieve all the records for the report and calculate how many pages long the report will be. Is there an option so that the number of pages in a thread are not displayed? Maybe move that thread to it's own section, or create a whole new section for member pictures? (IMG:style_emoticons/default/confused24.gif) |
Allan |
Aug 17 2004, 05:22 PM
Post
#18
|
Teenerless Weenie Group: Members Posts: 8,373 Joined: 5-July 04 From: Western Mesopotamia Member No.: 2,304 Region Association: Southern California |
It just gives me something to look forward to if it dosn't load right away. (IMG:style_emoticons/default/biggrin.gif)
|
anthony |
Aug 17 2004, 05:27 PM
Post
#19
|
2270 club Group: Benefactors Posts: 3,107 Joined: 1-February 03 From: SF Bay Area, CA Member No.: 218 |
QUOTE Anything better than a P2 should run this site fine, it's probably how the db is configured. Might need an index on a table somewhere or something... My guess is that that isn't true. The server isn't just serving up static pages. Since the site uses PHP, the server has to process and put together every page from the DB. Is it possible to do some benchmarking to see where the bottlenecks are? |
Gint |
Aug 17 2004, 05:53 PM
Post
#20
|
Mike Ginter Group: Admin Posts: 16,083 Joined: 26-December 02 From: Denver CO. Member No.: 20 Region Association: Rocky Mountains |
I've suspected the DB for some time now. But I'm no DBA...
I've temporarily moved the "Members 914 pictures" and the "What the heck do you look like?" threads to the Classic Message Threads forum. Let's see what happens now. There is an option to "split" threads. If this temp move helps, maybe we can try that with the biggies. |
Lo-Fi Version | Time is now: 8th June 2024 - 02:24 AM |
All rights reserved 914World.com © since 2002 |
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |