Find() failing due to '2006: MySQL server has gone away'

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php