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?
Regards,
Saša Stamenković
On Thu, May 20, 2010 at 3:14 PM, Саша Стаменковић <umpir...@gmail.com>wrote:
> Only in development environment :)
>
> Thanks.
>
> Regards,
> Saša Stamenković
>
>
>
> On Thu, May 20, 2010 at 3:13 PM, Daniel Latter <dan.lat...@gmail.com>wrote:
>
>>
>> Ive heard about a problem with the zf debug bar where it creates extra
>> connections? are you using this?
>>
>>
>> On 20 May 2010 14:07, Саша Стаменковић <umpir...@gmail.com> wrote:
>>
>>> I'm on shared hosting, so I can't do that.
>>>
>>> I'm quoting like this:
>>>
>>> return $this->fetchAll(
>>> $this->select()
>>> ->from($this->_name)
>>> ->where($this->getAdapter()->quoteInto($this->_name . '.id IN (?)', $ids,
>>> Zend_Db::INT_TYPE))
>>> ->order('date DESC')
>>> );
>>>
>>> where $ids is array of table primary keys.
>>>
>>> Regards,
>>> Saša Stamenković
>>>
>>>
>>>
>>> On Thu, May 20, 2010 at 3:02 PM, Thomas D. <whist...@googlemail.com>wrote:
>>>
>>>> Hi,
>>>>
>>>> Саша Стаменковић wrote:
>>>> > I don't know how to monitor mysqld, maybe get connection
>>>> > from adapter with getConnection() and then retreive it from there and
>>>> log?
>>>>
>>>> No. Monitoring your mysqld has nothing to do with PHP.
>>>>
>>>> If you are on Unix or FreeBSD, you would use a tool like "mtop".
>>>> If you are on Windows you can use the MySQL Administrator from
>>>> mysql.org.
>>>>
>>>>
>>>> P.s.: When you are quoting, how do you do that?
>>>> $table = new MyZendTable();
>>>> $adapter = $table->getAdapter();
>>>>
>>>> $quoted_string = $adapter->quote(...);
>>>>
>>>> If you are using "getConnection()" you will create an additional
>>>> connection/object and won't use the existing one.
>>>> Maybe this is your problem...
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Thomas
>>>>
>>>>
>>>>
>>>
>>
>
