Optimizing Zend_Db_Table SQL Query Count for Multiple Reference Tables

Recently I have started to use Zend Framework for a new project in the company. I have designed my database tables and then created some models for my MVC with Zend_Db_Table. When I wanted to show a detail page for a row in a table which had 4 foreign keys, I needed to make some joins in the sql which I was unable to do and used findParentRow() method which was a huge miskate. That’s where the story begins.
Continue reading Optimizing Zend_Db_Table SQL Query Count for Multiple Reference Tables