>>I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's.
Keep in mind that primary keys are by definition indexed, and in order to maintain an index, keys are compared to others. Now comparing to numbers takes only one machine instruction, while comparing 32 bytes string takes a loop of potentially 32 comparisons. So auto-incrementing integers are much more efficient. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:301905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
