I'm asking because I see quote method in exception trace:
2010-05-20T10:08:40+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('582',
NULL)
#2 Zend/Db/Select.php(1000): Zend_Db_Adapter_Abstract->quoteInto('table...',
'582', NULL)
#3 Zend/Db/Select.php(475): Zend_Db_Select->_where('table...', '582', NULL,
true)
...
Regards,
Saša Stamenković
On Mon, May 24, 2010 at 4:11 PM, Саша Стаменковић <umpir...@gmail.com>wrote:
> I'm pretty sure it's one connection too, but for quoting value, does
> Zend_Db_Adapter contacts mysql server in order to get some info about how to
> quote it?
>
> Regards,
> Saša Stamenković
>
>
>
> On Mon, May 24, 2010 at 4:03 PM, Thomas D. <whist...@googlemail.com>wrote:
>
>> Hi,
>>
>> Саша Стаменковић wrote:
>> > Yeah, quoteInto connects to db for every quoted value,
>> > and that breaks my limit of 15 queries at once,
>> > even I only run one select and one update query,
>> > it quotes array of values. What should I do?
>>
>> I cannot believe this. If this would be true, this would be a big bug.
>> Think about the impact on performance.
>> I am monitoring our mysqld while developing and I didn't see such a
>> behavior. Only one connection is established per database and used across
>> multiple Zend_Db_Table instances.
>>
>> So there must be something wrong in your code. E.g. a logical error (wrong
>> usage).
>>
>> What I would do:
>> I would run this code locally in a debugger and watch the mysqld query
>> log. Then you should know, where's the problem is located.
>>
>>
>> --
>> Regards,
>> Thomas
>>
>>
>>
>
