Zero2Cool
13 years ago
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.
UserPostedImage
wpr
  • wpr
  • Preferred Member
13 years ago
great. site seems faster with page loading too. Firefox and windows 7
UserPostedImage
Zero2Cool
13 years ago

great. site seems faster with page loading too. Firefox and windows 7

Originally Posted by: wpr 



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
Zero2Cool
13 years ago
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.


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.

Originally Posted by: Zero2Cool 



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
Fan Shout
Zero2Cool (6m) : found bad sql in database, maybe site faster now?
dfosterf (5-Aug) : I'm going to call that a good move.
Zero2Cool (4-Aug) : Packers sign CB Corey Ballentine
Zero2Cool (4-Aug) : I'm not sure how to kill the draft order just yet so it's not so confusing.
Mucky Tundra (4-Aug) : *to be able
Mucky Tundra (4-Aug) : and because it's not a dynasty league (which makes a lot more sense to be ability to trade picks)
Mucky Tundra (4-Aug) : Oh I know; I was just exploring and it blew my mind that you could trade picks because of the whole reordering thing
Mucky Tundra (4-Aug) : Zero, I think I preferred my offer: your 1st for my 15th rounder
Zero2Cool (4-Aug) : Keep in mind, we do a draft reorder once all members locked in
Zero2Cool (4-Aug) : You can have my 12th Rd for your 2nd round
Mucky Tundra (4-Aug) : Hey i didn't know we could trade picks in fantasy
Mucky Tundra (3-Aug) : Update: Rock has tried a cheese curd, promises it's not his last
Zero2Cool (3-Aug) : watch it!! lol
Mucky Tundra (3-Aug) : you're right, we never did leave, the site just went down :P
Mucky Tundra (3-Aug) : Rock claims to have never eaten a cheese curd
Zero2Cool (3-Aug) : We did not leave.
Mucky Tundra (3-Aug) : Family Night! WE ARE SO BACK!
Mucky Tundra (2-Aug) : To this day, I'm still miffed about his 4 TD game against Dallas on Thanksgiving going to waste
Martha Careful (2-Aug) : Congratulations Sterling Sharpe. He was terrific and I loved watching him play.
beast (2-Aug) : I believe it's technically against the CBA rules, but Jerry just calls it a simple unofficial chat... and somehow gets away with it.
beast (2-Aug) : Jerry Jones is infamous for ̶n̶e̶g̶o̶t̶i̶a̶t̶i̶n̶g̶ chatting with players one on one... and going around the agent.
Mucky Tundra (1-Aug) : Oo just saw a blurb saying that Dallas negotiated directly with Parsons and not through his agent
Mucky Tundra (1-Aug) : I assumed that both guys will get paid, just a matter of when or how we get there
Zero2Cool (1-Aug) : McLaurin nor Micah going anywhere. They will get money
Mucky Tundra (1-Aug) : the Synder years or do they take care of one of their own?
Mucky Tundra (1-Aug) : Do the Commanders risk losing a top WR with an emerging QB just because he's turning 30 and potentially risk damaging the rebuild from
Mucky Tundra (1-Aug) : Turns 30 this September, plays at a high level and Washington has some cap space I believe
Mucky Tundra (1-Aug) : More interesting is Washington with Terry McLaurin
Mucky Tundra (1-Aug) : I would imagine Dallas will resolve this issue with a truckload of money
Zero2Cool (1-Aug) : Micah pulling a Myles with trade request
beast (1-Aug) : Packers should make some cheese forks
Mucky Tundra (31-Jul) : GRAB THE PITCHFORKS~
Zero2Cool (31-Jul) : CUT HIM
Mucky Tundra (31-Jul) : Socieltal collapse imminent
Mucky Tundra (31-Jul) : The West has fallen
Mucky Tundra (31-Jul) : After starting off camp with 25 straight made field goals, Brandon McManus has missed one
Zero2Cool (31-Jul) : But it should be stable
Zero2Cool (31-Jul) : It's probably gonna be slower.
Zero2Cool (31-Jul) : We're gonna just full go on to the new host.
Zero2Cool (31-Jul) : What crap. Site issues galore
Zero2Cool (30-Jul) : if PH dies, there is packerpeople com available
Zero2Cool (30-Jul) : database is on new host, eventually website will follow
Mucky Tundra (30-Jul) : Zero, regarding Ewers, you are correct.
Zero2Cool (30-Jul) : Sadly, this might be our life for awhile. I could put it on another host, but seems it was slower, although more stable
beast (30-Jul) : How long will it be down?
beast (30-Jul) : RIP site 😭
Zero2Cool (30-Jul) : Site will die, I have to restart it.
Zero2Cool (30-Jul) : Quinn stinks. Lot of underthrows. (my guess)
beast (30-Jul) : How did Quinn Ewers effect where Golden was drafted?
dfosterf (30-Jul) : All I've experienced was late at night or early morning. I just figured you were doing something in the background
Please sign in to use Fan Shout
2025 Packers Schedule
Sunday, Sep 7 @ 3:25 PM
LIONS
Thursday, Sep 11 @ 7:15 PM
COMMANDERS
Sunday, Sep 21 @ 12:00 PM
Browns
Sunday, Sep 28 @ 7:20 PM
Cowboys
Sunday, Oct 12 @ 3:25 PM
BENGALS
Sunday, Oct 19 @ 3:25 PM
Cardinals
Sunday, Oct 26 @ 7:20 PM
Steelers
Sunday, Nov 2 @ 12:00 PM
PANTHERS
Monday, Nov 10 @ 7:15 PM
EAGLES
Sunday, Nov 16 @ 12:00 PM
Giants
Sunday, Nov 23 @ 12:00 PM
VIKINGS
Thursday, Nov 27 @ 12:00 PM
Lions
Sunday, Dec 7 @ 12:00 PM
BEARS
Sunday, Dec 14 @ 3:25 PM
Broncos
Friday, Dec 19 @ 11:00 PM
Bears
Friday, Dec 26 @ 11:00 PM
RAVENS
Saturday, Jan 3 @ 11:00 PM
Vikings
Recent Topics
1h / Fantasy Sports Talk / macbob

2h / Around The NFL / wpr

5-Aug / Green Bay Packers Talk / beast

5-Aug / Green Bay Packers Talk / wpr

4-Aug / Green Bay Packers Talk / bboystyle

3-Aug / Green Bay Packers Talk / Mucky Tundra

3-Aug / Green Bay Packers Talk / beast

3-Aug / Feedback, Suggestions and Issues / Zero2Cool

2-Aug / Green Bay Packers Talk / Mucky Tundra

2-Aug / Green Bay Packers Talk / wpr

28-Jul / Random Babble / Zero2Cool

28-Jul / Green Bay Packers Talk / Mucky Tundra

28-Jul / Green Bay Packers Talk / Mucky Tundra

27-Jul / Green Bay Packers Talk / Mucky Tundra

27-Jul / Green Bay Packers Talk / beast

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