Greenguy's Board


Go Back   Greenguy's Board > General Business Knowledge
Register FAQ Calendar Today's Posts

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 2009-04-11, 03:59 PM   #1
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,826
Send a message via ICQ to Toby
Quote:
Originally Posted by Greenie View Post
That's a lie. I refuse to believe that the programmers could not include the paysite's & affiliates code into the new system.

Hell, here's the solution: if my new "unique" account number is 1234567, then have a database that has ALL my old codes in it. Each time it sees one, like 581222 for Amateur facials, replace it with 1234567.

Problem solved.
Greenie, I understand that you don't like change, but I really think you're being a little unreasonable about this.

Adding that additional data for every existing affiliate and the corresponding data lookup for every affiliate link processed isn't as simple as you make it sound. There are substantial side effects and consequences. Hence my mentioning "large high volume database remaining online and stable" in my earlier post.
Toby is offline   Reply With Quote
Old 2009-04-11, 04:13 PM   #2
MadCat
If something's hard to do, then it's not worth doing
 
MadCat's Avatar
 
Join Date: Sep 2008
Location: Berlin, Germany
Posts: 247
Quote:
Originally Posted by Toby View Post
Greenie, I understand that you don't like change, but I really think you're being a little unreasonable about this.

Adding that additional data for every existing affiliate and the corresponding data lookup for every affiliate link processed isn't as simple as you make it sound. There are substantial side effects and consequences. Hence my mentioning "large high volume database remaining online and stable" in my earlier post.
Also to grab this in from your earlier post:

Quote:
Yes, that would have been an ideal solution, but when you're talking about implenting changes across such a large high volume database while it remains online and stable, there are simply some limitations to what can be done.
There's a reason that in the software development best practices there is such a thing as a "testing environment" -- a set of systems that mimics the production environment that can be used for testing.

Also, the procedure to switch from one db to another db is this:

1: Get new hardware
2: Set up new DB (dbnew)
3: Poke up the new system and point it at dbnew
4: The new system should in fact be able to update both the dbnew and the old db (dbold).
5: Run both db's simultaneously
6: check db's daily for differences
7: fix whatever is causing differences
8: switch over fully

Presto.

There's a ton of methods to do a live transfer between different db's -- high volume or not. If they are doing anywhere near the amount of db transactions I think they're doing they will have a high availability cluster anyway, and the money to get a 2nd cluster set up for the new system.

All it requires is people that know what they're doing.
__________________
What's blue and not heavy?
MadCat is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:48 AM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc