Perhaps you need to optimize your query/indexes. Have you considered creating a (database) view?
On Wed, Mar 14, 2012 at 7:32 PM, Kro <[email protected]> wrote: > I have a find() call which sometimes takes a long time to complete, > depending on the date range selected by the user. This can sometimes cause > the server to time out (2006: MySQL server has gone away), causing the > find() to fail. I have tried altering the timeout value using the following: > ini_set('mysql.connect_timeout', 5); > > My presumption is that this is failing because I cannot override the server > settings on the hosting package. > I was advised by the hosting company to use the following code: > SET @@session.wait_timeout=60 > > I would be very grateful for any advice on increasing the MySQL server > timeout through CakePHP. > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
