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 : Saturday, May 5, 2012 5:01:00 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,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Older messages, as in the ones prior to the switch last year, should appear easier to read now. We are back to our full archive.

Edited by user Wednesday, May 23, 2012 8:59:25 AM(UTC)  | Reason: Not specified


UserPostedImage
Click here and find the LATEST Packers News!
Sponsor
Offline wpr  
#2 Posted : Saturday, May 5, 2012 7:10:16 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,352
Joined: 8/8/2008(UTC)

Applause Given: 2,752
Applause Received: 1,322

great. site seems faster with page loading too. Firefox and windows 7
"You don't hurt 'em if you don't hit 'em." Chesty Puller



UserPostedImage

Offline Zero2Cool  
#3 Posted : Saturday, May 5, 2012 9:26:57 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,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Originally Posted by: wpr Go to Quoted Post
great. site seems faster with page loading too. Firefox and windows 7


I had noticed that myself, but figured it was because no one was here, lol. Maybe with the database completely normalized now it'll function more smooth.

UserPostedImage
Click here and find the LATEST Packers News!
Offline Zero2Cool  
#4 Posted : Wednesday, May 23, 2012 8:54:40 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,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

can't say the load times maintained their snappiness, but I did find some notes from August 2011 about fixing all the old posts, lol.


Originally Posted by: Zero2Cool Go to Quoted Post
Possibly found a way to update the posts from the old board with correct formatting.

To accomplish the task...
- Copy site files from live site, to beta
- Backup database, change web.config to point to PHBeta
- Delete all topics prior to May 15th, 2011 that do not have a post after said date
- Delete all posts prior to May 15th, 2011
- Re-code C# app to read MySQL PHBackup database and manipulate data appropriately into SQL PackersHome database.
-- Do NOT insert topics/messages where the TopicID/MessageID is greater than the first TopicID/MessageID after transition
-- SET IDENTITY_INSERT tblName ON (use this with actual post ID's from MySQL DB, make sure no over lapping will occur!

Go through old notes and verify this is possible before proceeding.


The method I did was more complex, but easier and eliminated any possible data loss. I'm proud of how smooth that went, and surprised, lol.


UserPostedImage
Click here and find the LATEST Packers News!
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
24m / Green Bay Packers Talk / Mucky Tundra

2h / Green Bay Packers Talk / uffda udfa

4h / Green Bay Packers Talk / Dexter_Sinister

4h / Green Bay Packers Talk / Dexter_Sinister

4h / Green Bay Packers Talk / Dexter_Sinister

4h / Green Bay Packers Talk / Dexter_Sinister

5h / Random Babble / dfosterf

5h / Green Bay Packers Talk / nerdmann

10h / Green Bay Packers Talk / Dulak

12h / Green Bay Packers Talk / StoicFire

12h / Green Bay Packers Talk / mi_keys

01-Aug / Green Bay Packers Talk / uffda udfa

31-Jul / Green Bay Packers Talk / DarkaneRules

31-Jul / Green Bay Packers Talk / DarkaneRules

31-Jul / Green Bay Packers Talk / nerdmann


Tweeter

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