(This might have already been mentioned, sorry lost some emails) ...
I think no matter what ORM framework you pick you always have to look
@ its lazy + eager loading options (this is even before the
optimization). You can run into big problems if you don't consider
the timing of data in your app, most ORM fanatics think its great
that you get all that functionality and some praise caching as a
solution but never realize they are working with stale child objects
in the end and have to code workarounds themselves.
For the most part the agile benefit of using it in dev environment
outweighs this issue but definitely something to review in a project.
- Jon
On Sep 12, 2007, at 12:36 PM, Rob Marscher wrote:
I think ORM definitely fits a lot of common models. It can be
great for rapid development which is why frameworks like Ruby on
Rails and CakePHP have it build in. You just define the fields and
the relationships to other objects and the built in methods for
saving the objects (which will maintain your foreign keys),
retrieving an object (and their related objects), and get listings
of objects work without any additional coding.
There are other cases where you might need tables that don't fit to
an OOP model -- or you need custom sql to get the best optimized
listings. Even if you use ORM, you still need to understand the
SQL layer underneath to really optimize your application.
I haven't used the open source php ORM solutions (Propel, CakePHP,
etc) -- but I hear there are ways to configure/tune them to get
better optimized sql under-the-covers. That would be a
presentation I'd like to see. Anyone have experience with this?
-Rob
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
