Using Zend_Db_Profiler_Firebug and FirePHP to profile our code, all other queries after the connect is fast, but it seems to take forever for Zend Framework to establish a connection to mysql, I've googled the problem and others suggest using table metadata cache which I did, but the problem still persists.\[code\]ZendDbTableAbstract::setDefaultMetadataCache(ZendRegistry::get('cache'));\[/code\]We're using ZF 1.7, php 5.2 and Mysql 5.1, please see the screenshot for more details.
I'm beginning to suspect this could be a Mysql configuration issue and I'm going to look into that now, but I do appreciate any ideas or suggestion regarding this problem, thanks.