One issue with GUID's with CreateUUID() is that there is an overhead in creating them. One my machine it is about 15ms per call of CreateUUID(). If you are inserting 1000 rows and creating the GUID yourself, this can add 15 seconds of overhead (I had an app that did this).
We use Oracle. To overcome this, what we do is put a default on any GUID column of RawToHex(SYS_Guid()) and use Replace(CreateUUID(), "-", "", "all") for creating the GUID from CF. This gives compatible 32-character GUID's. When we are inserting rows that we want to select back out immediately, we create the GUID in CF. When we are doing bulk inserts, we leave the GUID null and let Oracle create it (which is much, much faster). Jon >>> [EMAIL PROTECTED] 12/8/2004 7:39:15 AM >>> from what you know/read have you seen any performance notes on using GUID's vs. Identity int's? ---------------------------------------------------------- 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]
