This isn't something which I have considered. I am not familiar with creating VIEWS. The tables which are queried are not static, the content can change all the time. Would a VIEW be appropriate in this situation?
On Monday, 19 March 2012 20:13:57 UTC, cricket wrote: > > 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
