[Eric Kennedy]

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.

[ignition25]

Nice! Congrats!

[Trejder]

Eric Kennedy, on 10 December 2010 - 11:32 PM, said:

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.

Thanks for your answer and happy vacation then.

[Trejder]

qiang, on 09 December 2010 - 11:38 AM, said:

Make sure you turn on schema caching for AR. Otherwise, a lot of time in AR would be spent in retrieving schema information. With proper configuration, AR should lower the performance of DAO/PDO by 50% or less.

An alternative solution is presented in this Wiki article.

[StErMi]

Can someone do a comparative with also PostgreSQL ?

[samdark]

PostgreSQL works just fine. Russia Today's MeetFrieds runs on it and Yii 1.0.

[StErMi]

samdark, on 15 December 2010 - 12:14 PM, said:

PostgreSQL works just fine. Russia Today's MeetFrieds runs on it and Yii 1.0.

I know that it's working fine, I was just wondering if there is a gap between mysql and postgresql

[Trejder]

StErMi, on 15 December 2010 - 01:42 PM, said:

I know that it's working fine, I was just wondering if there is a gap between mysql and postgresql

StErMi, as far as I'm concern we are not discussing a gap between two different RDBMSes here but the difference (gap) between using an older framework and switching to Yii with using the same RDBMS. Only this way you can correctly evaluate performance change between frameworks and that's what this topic started from (though got a bit off-topic by the way! :])

[beatyale]

This is a great site.

[Leric]

Yet another proof of the power of Yii

[koloale]

Is RealSelf.com is open source?

[samdark]

No.

[adiasen]

Hello,

may I ask you what the hardware setup for RealSelf.com is? Is the website running on single server or over multiple servers?

Thank you for your answer!

Cheers

[Kinetik]

Wow. Great performance!
Congratulation on your project!

[omarxp]

wow, cool.

[Mike Chojnacki]

Nice to see the speed increase* even without memcache =)

edit*

[g0dspeed]

Lol nice performance. Nothing in comparable to drupal lol

[gear]

Given that the core of Drupal is CMF, what sort of CMS do you use on yii? Any recommendation?

[jackjermey]

Great post Eric.
I'm in the same situation with a client project and it never occured to me that Yii could be an alternative to Drupal before I read your post and blog.

Tx for sharing.