HABTM and associations and loading

I have a database of 20 tables and several belongsTo, hasMany, and
HABTM relationships. When I have all my relationships loaded into the
models and turned on the program never runs. When I take out two of
the HABTM that I will rarely use or can write a custom bindModel to
run, then the application runs, but on viewing one page loads all the
models into memory (or at least it seems as such since it caches all
the tables).

Now I went through and aggressively took out any associations that I
didn't think would be used often. The remainder I plan on using
bindModel as needed to load them. My question is does anyone know
what the performance ramifications are to this model? Should I let it
load all of them and keep the associations loading essentially the
entire application? What kind of performance hit is there on
bindModel versus setting it in the model? And also does bindModel
offer any caching to it or does it build it all from scratch every
time?

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---