On Fri, May 28, 2010 at 9:54 AM, Grigore Dolghin <[email protected]> wrote: > I completely, wholehearted, 100% agree. GUID is the WAY to go - > started using them as PKs back in 2004 I think, when I was asked to > unify the databases of a program created by me and installed initially > in two different locations. 1 year later they came and said "well, > Grig, can you put them together?". Guess what, they were using > integers identity as keys. Well, I was pretty much f*cked up for one > week or so, writing scripts to re-sync those damn integers. Moved to > GUIDs and never looked back. -------------------
Are you my twin? In 2004-2005 I had that same hell to move data between stage and production for new customers. They had to approve their changes and receive output, printed checks in this case, and accept everything. Then someone had to move all the metadata, me of course, to production. Took two months for webpage changes to deal with GUID instead of ints. Then the scripts to modify the data schema and rekey it all. Those days really sucked and I will never replay that game again! > I heard concers about speed of GUIDs versus integers. While integers > are indeed faster, the difference is not that big at all. ---------------------- GUID is not slower unless you are pulling tens to thousands of rows and then it is fractional. When you take into consideration that you NO LONGER need to get a reply from your insert statement about the new key you have made the cross over in faster speed usage by your users. IMO YMMV ;-> You can make a UDF in the db that will give you the textual data Customer.Name if you want so you can "see" what you wanted to see. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
