You should try an approach that works well for Peoplesoft

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #207,395 by folkert 5/14/05 10:13:26 AM Reply	You should try an approach that works well for Peoplesoft They add columns, populate, keep the old columns around until the next change. Then remove the old column when you add/replace another column. IOW Column Deletes are done the following change. It is a matter of PROCEDURE. YOU HAVE TO COMMIT TO IT, or you'll end up with a HUGE amount of data that is not needed. Yes, it bloats the DB, but then you have a neat feature of Covering Your Ass. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* [image\|http://www.danasoft.com/vipersig.jpg\|\|\|\|]
Post #207,396 by boxley 5/14/05 10:25:24 AM Reply	gotta write that one down, thanx All tribal myths are true, for a given value of "true" Terry Pratchett [link\|http://boxleys.blogspot.com/\|http://boxleys.blogspot.com/] Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 48 years. meep questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org]
Post #207,515 by drewk 5/15/05 5:57:37 PM Reply	Already do that But there's still two problems. 1) Are you sure nothing else is using that column you're about to drop? Really really sure? Because you may not have been religious about using stored procedures for updates. in fact, if you're using MySQL then you definitely weren't. 2) Yes, you have to commit to it. Who's responsible for making sure it's followed? Who's responsible for defining the procedure to begin with? Bottom line, any non-trivial DB should be run by a non-trivial DBA. I am a trivial DBA. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]

Any DBAs want to do some consulting? - (drewk) - (14) - May 13, 2005, 08:39:35 AM EDT

Sorry, I don't get it. Aren't (eg) tabledefs also just code? -NT - (CRConrad) - (11) - May 13, 2005, 02:18:01 PM EDT

Rollback is different, some actions are non-reversible - (drewk) - (10) - May 13, 2005, 03:02:14 PM EDT

Ah. OK, I see what you mean. But... - (CRConrad) - (9) - May 13, 2005, 03:16:48 PM EDT

Maybe you're used to different hardware than I am - (drewk) - (8) - May 13, 2005, 03:53:18 PM EDT

couple of points - (cforde) - (4) - May 14, 2005, 02:34:34 AM EDT

A mysqldump can be slower than a select * into ... - (static) - May 15, 2005, 11:21:55 PM EDT

Not on MySQL any more - (drewk) - (2) - May 16, 2005, 11:58:16 AM EDT

Then you need to slow down. WTF is that place - Fever City?! -NT - (CRConrad) - (1) - May 16, 2005, 01:29:44 PM EDT

How many developers in your departement? - (drewk) - May 16, 2005, 02:07:00 PM EDT

You should try an approach that works well for Peoplesoft - (folkert) - (2) - May 14, 2005, 10:13:26 AM EDT

gotta write that one down, thanx -NT - (boxley) - May 14, 2005, 10:25:24 AM EDT

Already do that - (drewk) - May 15, 2005, 05:57:37 PM EDT

email me - (broomberg) - (1) - May 13, 2005, 08:55:58 PM EDT

Still trying to find all that out - (drewk) - May 15, 2005, 05:59:34 PM EDT

iwethey.org

Only technical details are missing.
65 ms