Cake PHP: Containable Behavior or Model Unbind - which is good for Optimizing Query in Cake PHP

Question

I'm working on a project based on Cake PHP.On that project recursive = 2 is used and that makes the application slow. Now I need To Optimize Some Query for slow response. For optimizing Query I can Follow two steps:

1. UnbindModel

2. Containable Behavior

My Question is When I Should use Containable Behavior and when unbinding Models.I Think I need Some Clear Explanation From Cake PHP Expert.

Always use `Containable` - it's simpler to use, easier to read and does `unbind` under the hood anyway. — lethal-guitar, Mar 31 '14 at 10:11

score 2 · Accepted Answer · answered Apr 01 '14 at 10:12

You should always be using either Containable or recursive=>'-1'
Cache your queries when it's possible (when you're requesting the same data multiple times)
Only ask for what you need using the fields parameter
Add appropriate indexes to your MySQL database tables

Those are just some of the quickest ways to optimizes your queries. There are also ways to optimize queries using bindModel for certain requests, or restructuring your tables in certain ways, but those are very situation-specific.

Cake PHP: Containable Behavior or Model Unbind - which is good for Optimizing Query in Cake PHP

1. UnbindModel

2. Containable Behavior

1 Answers1