For what it's worth I kind of agree with the others about the performance benefits... but at the same time the busiest site I've ever worked on (and my personal site, since it's built using the same engine) uses only UUIDs for PKs and never had an issue because of it.
We used them, as I assume you are, to ensure that cross-domain information could be easy combined (something we actually didn't end up doing) and used in the application (the same PKs were used as StructKeys in session management) but we took millions of hits on moderate hardware using CF 6, Windows and SQL Server and it never winced. At the same time I kind of DON'T agree with them if you're doing what we were doing: if you're using the key to link tables (so that you can combine multiple databases easily) and using them to link to non-DB information (log files, etc) then it seems like extra work to do a "real" auto-increment PK as well. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
