I've never had anything to do with tables that large either, but if you're worried about it exclusively locking the table, could you DTS the records to a new table containing the additional column, and then after it's successfully processed everything, drop the existing table and rename the new one? That would have your data locked only for a few milliseconds, wouldn't it? Or does DTS lock the table too?
Are you working on a live data table or a dev copy of it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 March 2003 2:09 AM To: CF-Talk Subject: RE: big database (need to modify columns) but from query analyzer I should be ok? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:09 AM To: CF-Talk Subject: Re: big database (need to modify columns) Quoting Tony Weeg <[EMAIL PROTECTED]>: > > has anyone on here ever had to add a column or change a column's > properties. My database already has like 15 million rows of data in it? > > if so, how the HECK did you do it? ALTER TABLE table ADD COLUMN column datatype; Never done it on something larger as 8 million rows and it takes some time, but it is not something that ought to break anything. Just remember that this will most likely exclusively lock your table, and that CF (or any other web language) is not the right tool for it, but you need the native DB management tools. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
