Re: Main diference between INT and CHAR (uniqid) primary keys

UUIDs need way more "disk space". one might add that speed can also be
an issue.
having tables with a lot of foreign keys can be slowed down quite a
bit, even with indexing.
we have a project with uuids and tables with 1xxxx records get really
really slow.

on the other hand UUIDs are very handy if you want to "hide" the
current record count.
with AIIDs you always know how many users have been registered (= how
popular your site was):
200, 6000, ...
with UUIDs you have so such statistics anymore. this can be unwanted
or desired.

On 14 Jan., 19:31, jeremyharris <funeralm...@gmail.com> wrote:
> UUIDs are entirely unique while autoincrement ids are unique just for that
> table. The benefit of UUIDs would be for things like merging tables,
> merging other data, migrating the data elsewhere, etc. With UUIDs you
> guarantee there won't be conflicts.
>
> It's a matter of preference and depends on your project.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php