You should be able to use the same approach in the XAMPP environment
that validkeys pointed you to before.
The post was about setting up logging for MySQL, not MAMP specific.
On Nov 21, 4:29 am, "Liebermann, Anja Carolin"
<[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
