$this->Model->recursive = 0; <---try to put that beofre the findAll()... it will limit how many queries are made and how much data is returned.
Does this answer your question? On Jul 26, 8:12 am, Saymons <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I am using CakePHP 1.1.last_version_here and PostgreSQL 8.0.12 > I have a question about the belongsTo association : > > My models are the following : > Asset->HABTM Composer > Composer -> BelongsTo Composite(Asset) and Component(Asset) > > So an Asset can have many "sons" and many "parents" of the same type. > > When I'm loading an Asset, the models reads well the data about the > Asset himself, but when looking to the HABTM, it reads the Composer > table, and then for each row of the table, it reads the Composite and > the Component : > SELECT ... FROM tbl_asset WHERE id=12 -> gives me data about the asset > SELECT ... FROM tbl_composer WHERE component_id=12 -> gives me every > composite_id (let's say 15,17 and 21) > but then > SELECT ... FROM tbl_asset WHERE id=15 > SELECT ... FROM tbl_asset WHERE id=17 > SELECT ... FROM tbl_asset WHERE id=21 > > Is there a way that the Composer could join on the Asset table, not to > have so many queries ? > > Thx > > PS : excuse my English, i'm french --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
