More information about the Underscore mailing list

[_] CakePHP 1.2, ready for production?

Jon Bennett jmbennett at gmail.com
Tue Mar 18 12:41:38 GMT 2008

Hi Rich,

>  > from a pure db design perspective sure - but is there really that much
>  > harm in having an auto_increment id coupled with a unique index
>
>
> If you use InnoDB as your main storage engine, and your site is likely
>  to be popular, then yes! This *can* be a huge issue unless you upgrade
>  to MySQL 5.1, which is still only at RC stage :)

ahh, do you have any links to why? no doubting you just like to know the theory.

jb

-- 

jon bennett
w: http://www.jben.net/
iChat (AIM): jbendotnet Skype: jon-bennett