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, Саша Стаменковић <[email protected]> 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. <[email protected]>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 >> >> >> >
