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 ?