They search a LOT faster. I don't recommend UUIDs for this. Also, when doing joins, having UUIDs as FKs will be a bad thing... Hal, what's the scoop on UUID's? I JUST started using them for my PK's and would like to hear what you have to say on their usage as I'm not a real db guru, I only pretend while I'm at work so they give me more privileges!! Cheers, Emilio ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- RE: max_id or autonumber? Alan Dix
- RE: max_id or autonumber? Hal Helms
- Re: max_id or autonumber? Brian Scott Barnett
- Re: max_id or autonumber? Steve Nelson
- RE: max_id or autonumber? Patrick McElhaney
- Re: max_id or autonumber? Nat Papovich
- RE: max_id or autonumber? Marcus
- RE: max_id or autonumber? Mike Craig
- RE: max_id or autonumber? Mike Craig
- Re: max_id or autonumber? Nat Papovich
- RE: max_id or autonumber? Emilio
- RE: max_id or autonumber? Erik Voldengen
- Re: max_id or autonumber? Derek Hamilton
- Re: max_id or autonumber? Paul Smith
- Re: max_id or autonumber? Paul Smith
- RE: max_id or autonumber? Hal Helms
- Re: max_id or autonumber? Steve Nelson
- RE: max_id or autonumber? Stacy Young
- RE: max_id or autonumber? Stacy Young
- RE: max_id or autonumber? Ross Keatinge
- RE: max_id or autonumber? Stacy Young
