Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
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
Posts: 25,731
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,863
Applause Received: 2,027

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
Click here and find the LATEST Packers News!
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
Posts: 12,458
Joined: 8/8/2008(UTC)

Applause Given: 2,828
Applause Received: 1,364

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

Posts: 1,707
Joined: 10/12/2008(UTC)

Applause Given: 262
Applause Received: 226

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
Posts: 25,731
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,863
Applause Received: 2,027

Opened my browser, clicked my PH link.

This page was generated in 5.921 seconds.


That's unacceptable.

UserPostedImage
Click here and find the LATEST Packers News!
Offline Nonstopdrivel  
#5 Posted : Tuesday, October 11, 2011 5:56:52 PM(UTC)
Nonstopdrivel

Rank: Hall of Famer

United States
Posts: 11,689
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
Posts: 25,731
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,863
Applause Received: 2,027

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
Click here and find the LATEST Packers News!
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
Posts: 25,731
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,863
Applause Received: 2,027

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
Click here and find the LATEST Packers News!
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
Posts: 12,458
Joined: 8/8/2008(UTC)

Applause Given: 2,828
Applause Received: 1,364

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
Posts: 25,731
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,863
Applause Received: 2,027

We should be getting page generated in 0.075 seconds type o times.

UserPostedImage
Click here and find the LATEST Packers News!
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
Posts: 25,731
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,863
Applause Received: 2,027

The site seems to load quicker on IE9 than FireFox7.

UserPostedImage
Click here and find the LATEST Packers News!
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

Posts: 1,707
Joined: 10/12/2008(UTC)

Applause Given: 262
Applause Received: 226

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
Rss Feed 
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.

Notification

Icon
Error

Recent Topics
now / Green Bay Packers Talk / nerdmann

40m / Green Bay Packers Talk / uffda udfa

2h / Around The NFL / Zero2Cool

8h / Green Bay Packers Talk / texaspackerbacker

9h / Green Bay Packers Talk / sschind

11h / Random Babble / Mucky Tundra

13h / Green Bay Packers Talk / nerdmann

20-Aug / Random Babble / DakotaT

20-Aug / Green Bay Packers Talk / texaspackerbacker

20-Aug / Green Bay Packers Talk / Cheesey

20-Aug / Green Bay Packers Talk / voiceofreason

19-Aug / Green Bay Packers Talk / musccy

19-Aug / Green Bay Packers Talk / mi_keys

19-Aug / Green Bay Packers Talk / Mucky Tundra

19-Aug / Green Bay Packers Talk / nerdmann


Tweeter

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