Finding a tag details from the suggested design by you, need to find
from all tables so extra 4 SQL Join query will be perform
1. tags_users (tag_id, user_id) (SQL Join)
2. brands_tags (brand_id, tag_id)
3 products_tags (product_id, tag_id)
4 posts_tags (post_id, tag_id)
Should I go ahead without worry abt SQL performance?
Thanks
On Oct 26, 4:14 am, RyOnLife <ryan.mckil...@gmail.com> wrote:
> I'm having some trouble with save/delete HABTM myself, but I can at least
> help you on your table design. Following Cake conventions (plural,
> lowercase, abc order) and assuming you want everything taggable, your join
> tables would be:
>
> tags_users (tag_id, user_id)
> brands_tags (brand_id, tag_id)
> products_tags (product_id, tag_id)
> posts_tags (post_id, tag_id)
> --
> View this message in context:http://n2.nabble.com/Tags-implementation-tp1376700p1377213.html
> Sent from the CakePHP mailing list archive at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---
No comments:
Post a Comment