Database Execution Time


I thought of testing Yii’s DB Performance with raw PHP code. This is what I did.

I created an action which retrieves around 5000 rows by DAO method and a simple PHP file to do the same action.

The result are like belows.

Yii : 0.0348 second

Plain PHP Code : 0.0207 second

I tried calculating just the query part, but still the results are same. The application I’m developing will have over 1 million rows atleast, i’m worried if the performance is going to be hurt.

Am I doing anything wrong here ? Or is the extra overhead causing these time difference ?

Why not you try Yii’s Active Records with raw php data retrieving codes?

Active Records are slow themselves. Compared to DAO, the performance of active record is very less.

DAO is roughly like twice better.