yep -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 15:09 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
