I don't know what you're trying to do so can't say whether it would be appropriate. But, unless you've got some strange configuration problem, the database timing out on you suggests that you're doing something inappropriate now. DB administration is a huge topic and there are plenty of ways to shoot yourself in the foot.
On Mon, Apr 16, 2012 at 4:46 AM, Kro <[email protected]> wrote: > 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 -- 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
