Matthew Setter has shared three tips to improve the performance of your Zend Framework-based application on his MaltBlue site today:
Today, I want to take you out left field a bit. I want to take you a little away from the everyday, potentially clichéd, advice you likely read when it comes to improving Zend Framework 2 application performance. There’s likely nothing wrong with it; but I’d say you’ve already read it many times. Instead, I’ll show you 3 strategies you may not have thought of – specifically focused around the database. That way, when combined with the standard advice, you’ll be better able to improve performance of your Zend Framework application.
As mentioned, his three tips involve working with database connections and resources:
- Improve your database skills
- Learn key database features
- Move logic to the database layer
This final tip advocates the use of things like stored procedures and triggers to handle some of the logic load of the system. This also reduces some of the network overhead as not as much information is having to be pulled "over the wire" as before.