What are the advantages in using composite primary key since it has been supported in cakephp v3?

Composite primary keys can be useful in multi-tenant applications. For example, if you app has discrete users that don't need to cross talk often. By usimg composite keys you can make the 'identifier' for a record the accountid + thingid. This allows each user to have thingid=1 if you wanted. Composite keys are also great for belongstomany joint tables.

If you are using Mysql there are some side benefits as well. MySql stores rows on disk based on the primary key. When yoou use composite keys mysql will cluster data for an account close together. This can make read queries faster as there are fewer disk seeks used to find the data for a given account.

-mark

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.