Join Our Green Bay Packers Interactive Community!

We have been providing fans with the best source of Packers information since 2006!
Your participation is greatly anticipated!
Login or Register.
Options
View
Go to last post Go to first unread
Offline Zero2Cool  
#1 Posted : Tuesday, October 11, 2011 2:09:22 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,911
Applause Received: 2,117

When you have something that you care about and it doesn't perform to your standards, it can be quite depressing for lack of a better word. I'm considering several options.

I can prune the database down to two years worth of posts in the Let's Talk Green Bay Packers section.

Pruning
Who would miss that data?
Does anyone actually care to look for that data?
Are there any type of threads that years from now you would want to review?

Prediction threads and GameDay threads are the only topics that I can think that anyone would actually want to review. In that case, we can create a sub forum (Shawn's idea) and place such posts there.

There is no guarantee that pruning the database would even improve the page load times.



New Host
Locate a new host, but then again, we'd have to prune the database to lower than 200MB (Currently we sit at 491MB).



I'm confident the software is not the issue as I've seen other sites have load times generated in 0.133 seconds where as we're seeing pages being generated in 0.438 seconds and sometimes taking 1 second or several seconds to display.


I'm open to all any ideas for improvement, or site diagnostics approaches to improve the site speed.

UserPostedImage
Sponsor
Offline wpr  
#2 Posted : Tuesday, October 11, 2011 2:47:15 PM(UTC)
wpr

Rank: Hall of Famer

PackersHome NFL Pick'em - Gold: 2012PackersHome NFL Pick'em - Gold: 2013FleaFlicker Fantasy Football - Bronze: 2013

United States
Joined: 8/8/2008(UTC)

Applause Given: 2,963
Applause Received: 1,428

I think it would be reasonable to prune old threads. Even the predictions. If they are 3 years old who really cares that back them Pack93 was genius or not?
"You don't hurt 'em if you don't hit 'em." Chesty Puller



UserPostedImage

Offline macbob  
#3 Posted : Tuesday, October 11, 2011 4:47:44 PM(UTC)
macbob

Rank: 2nd Round Draft Pick

Yahoo! NCAA March Madness - Gold: 2013FleaFlicker Fantasy Football - Silver: 2012PackersHome NFL Pick'em - Silver: 2012

Joined: 10/12/2008(UTC)

Applause Given: 289
Applause Received: 241

Not sure if you've already done something to speed things up, but the pages are loading noticeably quicker for me today.
UserPostedImage
Offline Zero2Cool  
#4 Posted : Tuesday, October 11, 2011 5:13:12 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,911
Applause Received: 2,117

Opened my browser, clicked my PH link.

This page was generated in 5.921 seconds.


That's unacceptable.
UserPostedImage
Offline Nonstopdrivel  
#5 Posted : Tuesday, October 11, 2011 5:56:52 PM(UTC)
Nonstopdrivel

Rank: Hall of Famer

United States
Joined: 9/14/2008(UTC)
Location: Germany

Applause Given: 364
Applause Received: 263

Assuming you haven't changed hosts since the last time you and I talked, I think it is your host that's the root of the problem. I am on the same host with a barebones phpBB installation and a minuscule database of a 5.08 MiB, and I still experience excruciating load times now and then. It's a function of being on a shared server with "unlimited" bandwidth and space. From what I've read, our host is one of the most well-known in the budget hosting business and the slow service is endemic. It's not as bad as GoDaddy, obviously (they're intolerable), but it's not great either. Still, after coupon I paid all of $65 for two years' worth of hosting. I can't complain too much.

I'd rather you didn't prune the old threads. I sometimes cruise through them because they are interesting to me. Or maybe you could create an archive area (a subdomain perhaps) that wouldn't get loaded unless it was specifically visited?
UserPostedImage
Offline Zero2Cool  
#6 Posted : Tuesday, October 11, 2011 6:06:04 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,911
Applause Received: 2,117

I would rather not prune threads, but those more than 6 months old are all messed up, and if I move to a new host, they all seem to have a 200MB cap on them. So I would have to prune anyway.
UserPostedImage
Offline Zero2Cool  
#7 Posted : Thursday, October 13, 2011 9:50:35 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,911
Applause Received: 2,117

Wish I could afford a dedicated box, but oh well. I made some tweaks and apparently it hasn't helped.

This page was generated in 1.417 seconds.
UserPostedImage
Offline wpr  
#8 Posted : Thursday, October 13, 2011 9:55:15 AM(UTC)
wpr

Rank: Hall of Famer

PackersHome NFL Pick'em - Gold: 2012PackersHome NFL Pick'em - Gold: 2013FleaFlicker Fantasy Football - Bronze: 2013

United States
Joined: 8/8/2008(UTC)

Applause Given: 2,963
Applause Received: 1,428

works fine for me:

This page was generated in 0.275 seconds.
"You don't hurt 'em if you don't hit 'em." Chesty Puller



UserPostedImage

Offline Zero2Cool  
#9 Posted : Thursday, October 13, 2011 10:02:41 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,911
Applause Received: 2,117

We should be getting page generated in 0.075 seconds type o times.
UserPostedImage
Offline Zero2Cool  
#10 Posted : Friday, October 14, 2011 4:05:40 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,911
Applause Received: 2,117

The site seems to load quicker on IE9 than FireFox7.
UserPostedImage
thanks Post received 1 applause.
Methodikal on 10/14/2011(UTC)
Offline macbob  
#11 Posted : Friday, October 14, 2011 7:35:24 PM(UTC)
macbob

Rank: 2nd Round Draft Pick

Yahoo! NCAA March Madness - Gold: 2013FleaFlicker Fantasy Football - Silver: 2012PackersHome NFL Pick'em - Silver: 2012

Joined: 10/12/2008(UTC)

Applause Given: 289
Applause Received: 241

Originally Posted by: Zero2Cool Go to Quoted Post
The site seems to load quicker on IE9 than FireFox7.


I should have said earlier I'm using Windows 7 and IE9.
UserPostedImage
 
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2014, Yet Another Forum.NET
This page was generated in 0.259 seconds.

Notification

Icon
Error

Tweeter

Recent Topics
1m / Around The NFL / Pack93z

42m / Green Bay Packers Talk / Pack93z

1h / Random Babble / Smokey

1h / Green Bay Packers Talk / Smokey

2h / Random Babble / Smokey

2h / Green Bay Packers Talk / wpr

3h / Green Bay Packers Talk / texaspackerbacker

3h / Green Bay Packers Talk / QCHuskerFan

4h / Fantasy Sports Talk / Smokey

4h / Green Bay Packers Talk / texaspackerbacker

7h / Fantasy Sports Talk / Zero2Cool

7h / Green Bay Packers Talk / steveishere

13h / Green Bay Packers Talk / DoddPower

15h / Fantasy Sports Talk / Smokey

18h / Green Bay Packers Talk / dfosterf


Copyright © 2006-2014 PackersHome.com™. All Rights Reserved.