The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Zend Framework fetchRow problem

I'm totally confused by a database bug with the Zend Framework. The issue is that in the code below "$row = $resources->fetchRow($where);" is taking 4 or 5 seconds to execute. It still works, the data is fetched from the database. When I use a simple db query from the example in http://uk.php.net/manual/en/ref.mysql.php it executes instantly. I have tried different versions of the Zend Framework which makes no difference, on top of that I have another site on the same server that uses nearly identical code with no problem at all.

I am completely baffled by it. What would make it the fetchRow take so long but not make it fail or throw any errors? Any suggestions would be greatly appreciated.

I would try using the database profiler to see whats going on with your query, see if that can point anything out. Also, it might not be reporting an error depending on how your script is setup, is it throwing any exceptions? Failing that I would try posting onto the ZF mailing list, those guys all know what they're talking about and you'll be asking a lot of people who actually write the code for the framework