Using UIDs makes it much easier to move data between servers or databases or even tables later, too, if you ever need to. For instance, moving records from production down to staging, when there's been testing going on in staging ... may have 100 records with IDs between 105 and 204 in each database, and all the related child records are keyed off of them etc ... makes it very easy to move everything around when using UIDs. In general, I just find the fact that the ID really is unique to *that* record very useful.
---------------------------------------- From: "Phillip Vector" <[email protected]> Sent: Monday, December 20, 2010 12:58 PM To: "cf-talk" <[email protected]> Subject: Re: Auto Incrementing Seed vs CF UUID If you are using it as an ID, I go with UUID. Makes it a little harder to put into the URL to look up things they shouldn't. On Mon, Dec 20, 2010 at 9:34 AM, Brian Polackoff <[email protected]> wrote: > > So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5 > Ent and an enterprise application with millions of rows in the table? > > Thanks for all your feedback, > > Brian > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
