title: Fatal error: Maximum execution time of 60 seconds exceeded in \doctrine\lib\Doctrine\Collection.php on line 462
body: <p>Whats this??
  my query is:</p>
  
  <pre><code>    Doctrine_Query::create()
                  -&gt;select('rec.*')
                  -&gt;from('Records rec')                   
                  -&gt;execute();
  </code></pre>
  
  <p>Records table contains more than 20k rows.</p>
  
  <p>On executing query on page i am getting an error:</p>
  
  <pre><code>     Fatal error: Maximum execution time of 60 seconds exceeded in \doctrine\lib\Doctrine\Collection.php on line 462
  </code></pre>
  
  <p><strong>Edit</strong>
  but to retrieve the values from a table having records more than 20k its taking more than 60 seconds.. Why?? And i am using same table for retriving some other records with a where clause, its running perfectly.. </p>
  
  <p>Table Structure:</p>
  
  <pre><code> CREATE TABLE IF NOT EXISTS `records` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `school` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16334 ;
  </code></pre>
  
  <p>database is local.</p>
  
  <p>We can do one thing, we can select a single element. like: city...
  I tried that even then its giving the same error..</p>
  
  <p>Number of rows are 16333(exactly) and number of columns are 4 as mentioned in the table structure..</p>
  
  <p>Anybody who can tell me how to solve it???
  means why its not working.. mysql simple select query is working perfectly..</p>
  
  <p>EDIT----</p>
  
  <p><strong><em>can anybody explain why he/she voted my question "negative"</em></strong></p>