Connection is not persistant, maybe I should set 'persistent' => true and switch from MySQLi to PDO adapter? * * *What is the difference when I use persistant connection? * Regards, Saša Stamenković
On Mon, May 17, 2010 at 10:09 PM, Саша Стаменковић <[email protected]>wrote: > I have this: > > $row = $table->find($id); // Zend_Db_Table > $row->setReadOnly(false); > $row->status = 'ACTIVE'; > $row->save(); > > In for loop. When having for instance 20 iterations, it happends to get > > 2010-05-17T08:49:07+02:00 ERR (3): exception > 'Zend_Db_Adapter_Mysqli_Exception' with message 'User *** already has more > than 'max_user_connections' active connections' in > Zend/Db/Adapter/Mysqli.php:333 > Stack trace: > #0 Zend/Db/Adapter/Abstract.php(832): Zend_Db_Adapter_Mysqli->_connect() > #1 Zend/Db/Adapter/Abstract.php(902): > Zend_Db_Adapter_Abstract->quote('376', NULL) > #2 Zend/Db/Select.php(1000): > Zend_Db_Adapter_Abstract->quoteInto('table...', '376', NULL) > #3 Zend/Db/Select.php(475): Zend_Db_Select->_where('table...', '376', NULL, > true) > ... > > I am on shared FreeBSD hosting. > > Is it possible that there is some connection overhead that code like this > can generate? > > Regards, > Saša Stamenković >
