[fw-general] Re: Re: Saving many Zend_Db_Table_Rows in for loop

2010-05-27 Thread Thomas D.
Hallo, СЯшЯ СтЯменковић wrote: Still sometimes get PDOException with message 'SQLSTATE[42000] [1203] User *** already has more than 'max_user_connections' active connections As I said in the beginning of this discussion (and btw, we can say that this was the reason for your problem): When

Re: [fw-general] Re: Re: Saving many Zend_Db_Table_Rows in for loop

2010-05-27 Thread Bill Karwin
On May 27, 2010, at 11:09 AM, Thomas D. wrote: When you are allowed to have 15 connections to your database server, you can serve 15 requests at the same time, when every request will establish 1 connection. I completely agree with Thomas. If you are getting the error of too many

[fw-general] Re: Re: Saving many Zend_Db_Table_Rows in for loop

2010-05-27 Thread Thomas D.
Hi, Bill Karwin wrote: I wrote the following on the February thread with Ulf Wendel that you linked to, but I think it bears repeating: [...] Peter seems to say that the overhead of using prepared statements is that they are 14.5% *faster* than using a non-prepared query

Re: [fw-general] Re: Re: Saving many Zend_Db_Table_Rows in for loop

2010-05-27 Thread Саша Стаменковић
Sure, I'll monitor this, dont happen too often. Thanks. Regards, Saša Stamenković On Thu, May 27, 2010 at 8:27 PM, Thomas D. whist...@googlemail.com wrote: Hi, Bill Karwin wrote: I wrote the following on the February thread with Ulf Wendel that you linked to, but I think it bears