ActiveRecord vs DAO Peformance

Any idea which perform better, ActiveRecord or DAO ?

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

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

What about queries returning huge result?

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."

I had no problems yet with AR performance.

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