NEW #1
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
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.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #2
Avatar
wpr Preferred Member
Joined: Aug 08, 2008
Posts: 20,215
Avatar
wpr
Preferred Member
Joined:Aug 08, 2008
Posts:20,215
great.
site seems faster with page loading too.
Firefox and windows 7
0
SlickVision, Methodikal, Kevin and 5 others
NEW #3
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
wpr;210105great.
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.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #4
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
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.


Zero2Cool;187966Possibly 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.

0
SlickVision, Methodikal, Kevin and 5 others