On the subject of creating a guid before the insert, wouldn't you still have to query the db to make sure the guid isn't already in there. I know the chances are very, very slim, but it's not impossible, right?
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Dave Watts > Sent: Wednesday, December 08, 2004 9:42 AM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] GUIDs as Primary/Foreign Keys > > > from what you know/read have you seen any performance notes > > on using GUID's vs. Identity int's? > > I haven't run into any performance problems yet. Presumably, with a > large > enough dataset you might, but SQL Serve handles indexed strings nicely > enough in most cases. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at www.mail- > [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
