Trejder, on 09 December 2010 - 09:19 AM, said:
Can you be a little bit more specific on about DB operations topic? Can mention some numbers on what percent of DB-related operations in RealSelf.com are done via ActiveRecord and how many via DAO? Do you see any serious performance degrade / difference between these two methods? Are there any parts of code that are using pure PDO object, leaving all that comes with Yii behind?
All of our form queries use ActiveRecord. We use DAO for many of our complex select statements on model views. It makes sense to use an explicit query with DAO when that query will be run millions of times before a schema change occurs.
BTW, I'm on vacation for the next 2 weeks so expect replies after the 24th.