Database Execution Time

Yii 1.1 General Discussion
1

Hi,

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 ?

2

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

3

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

DAO is roughly like twice better.