ActiveRecord vs DAO Peformance

kram · August 17, 2009, 6:05am

Any idea which perform better, ActiveRecord or DAO ?

So1 · August 17, 2009, 6:30am

For a simple queries both are good. DAO should be used to execute ‘difficult’ queries.

kram · August 17, 2009, 7:00am

Are you saying that the DAO perform better in complex queries?

What about queries returning huge result?

kram · August 17, 2009, 9:22am

found this in documentation

"Do not overuse Active Record. Although Active Record is good at modelling data in an OOP fashion, it actually degrades performance due to the fact that it needs to create one or several objects to represent each row of query result. For data intensive applications,using DAO or database APIs at lower level could be a better choice."

rickgrana · August 18, 2009, 2:54am

I had no problems yet with AR performance.

However, if you really needs performance, i recommend you to use DAO.