Hi Validkeys,
Unluckily my development environment is a XAMPP. And for obvious reasons I
don't want to upload this code on the productive Linux environment. :c)
My find expression is as follows:
$textmaster = $this->Textmaster->find('all',
array( 'condition' => array ('Textmaster.id' => $id),
'contain'=> array(
'Textart'=> array(
'fields'=>array('id','name'),
'conditions'=>array('Textart.id ='=>'Textmaster.textart_id')),
'Verhoteltextmaster'=> array(
'Hotelmaster'=>array('fields'=>array('id','name'),
'conditions'=>array('Hotelmaster.id ='=>'Verhoteltextmaster.hotelmaster_id'))),
'Verorttextmaster'=> array(
'Ortmaster'=>array('fields'=>array('id','name'),
'conditions'=>array('Ortmaster.id ='=>'Verorttextmaster.ortmaster_id'))),
'Verzielgebiettextmaster'=> array(
'Zielgebietmaster'=>array('fields'=>array('id','name'),
'conditions'=>array('Zielgebietmaster.id
='=>'Verzielgebiettextmaster.zielgebietmaster_id'))),
'Katalogobjekt',
'Sprache',
'User'=> array(
'fields'=>array('fields'=>array('id','name')))
)//end contain
)//end conditions etc...
);//end find
Without the conditions I get a huge data array. What I wonder is if the
conditions reduce only the final array size in my controller or also the found
data by the SELECT query.
My
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[EMAIL PROTECTED] Im Auftrag von
validkeys
Gesendet: Freitag, 21. November 2008 13:19
An: CakePHP
Betreff: Re: How can I view the SQl Serach string?
If you are using MAMP:
http://particletree.com/notebook/logging-mysql-queries-on-mamp/
Otherwise, just find your Apache log, open up a *nix terminal, cd to the
directory with your mysql_sql.log file and type tail -f mysql_sql.log
That will auto udpate every time a query is passed and you can see everything
run through Apache. I am not to sure about the 2nd part of your question. What
do you mean "filter"?
On Nov 21, 5:54 am, "Liebermann, Anja Carolin"
<[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
> I have a quite complex find request with contain and my memory gets
> exhausted.
>
> 2 Questions:
> Ist: What I would like to know what exact SQL condition is generated.
> How can I view it before my browser throws the error with the memory?
> 2nd: Does contain filter the result after or before requesting them?
>
> Thank you in advance!
>
> Anja
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
