Viper X wrote:
conclusion: Zend_Db_Table is not good for heavy loaded web applications. My personal choice is to go with something like variant 4. The time overhead here is minimal and the code in the controller is most readable.
I agree with this. All ORM solutions are notorious for adding performance overhead. Their value is in extending the object-oriented paradigm to database programming.
There's no substitute for writing SQL queries by hand, if performance is your top priority. In fact, if performance is the only concern, you shouldn't be using an RDBMS at all -- you should be managing data using a custom storage module that you write, specialized to your application. Also, you shouldn't be coding in PHP in the first place -- you should be writing all your code by hand in assembler.
The point being that often a trade-off exists between development convenience and runtime speed.
Regards,
Bill Karwin
