Home  |  Forums  |  914 Info  |  Blogs
 
914World.com - The fastest growing online 914 community!
 
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.
 

Welcome Guest ( Log In | Register )

5 Pages V  1 2 3 > »   
Reply to this topicStart new topic
> 914club.com BBS is slow, anyone else notice this?
siverson
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Martin Baker
post 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)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
thesey914
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
machina
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
JWest
post 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.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Part Pricer
post 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)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
anthony
post 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.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
7391420
post 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....
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
KenH
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Brad Roberts
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Joe Bob
post 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.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Aug 17 2004, 03:03 PM
Post #12


Resident German
*************************

Group: Admin
Posts: 41,640
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
User is online!Profile CardPM
Go to the top of the page
+Quote Post
BMartin914
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
siverson
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
mikester
post 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:
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Brad Roberts
post 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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
ematulac
post 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)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Allan
post 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)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
anthony
post 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?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Gint
post Aug 17 2004, 05:53 PM
Post #20


Mike Ginter
***************

Group: Admin
Posts: 16,071
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.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

5 Pages V  1 2 3 > » 
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 17th May 2024 - 02:01 PM