Hi In my application I have the model "Item" and the model "User". Every item is visible by some users and it isn't visible by other users. So I have a HABTM between "User" and "Item". Now I must register when a user views an item and when a user selects a item (a user can select some visible items if he wants). To do this I have found 2 solutions: 1) Created two models "ItemSelection" and "ItemView" but if I must use INNER JOIN (for example If I would the list(with paginate) of users that have viewed and selected and certainly item) I have very very bad performance. 2) Add to the users_items table fields "viewed" and "selected" but I have a big table with many and many record with null value
I would ask if someone has this problom in the past and how he has resolved it. Many Thanks Bye Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
