Yii Framework Forum: RealSelf.com - 1.5 million monthly visitors - Yii Framework Forum

Jump to content

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

RealSelf.com - 1.5 million monthly visitors Rate Topic: ***** 16 Votes

#21 User is offline   Eric Kennedy 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 7
  • Joined: 28-November 10
  • Location:Seattle, WA

Posted 10 December 2010 - 11:32 PM

View PostTrejder, 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.
0

#22 User is offline   ignition25 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 24
  • Joined: 25-November 10

Posted 11 December 2010 - 12:10 PM

Nice! Congrats!
0

#23 User is offline   Trejder 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,197
  • Joined: 06-October 10
  • Location:Southern Poland

Posted 11 December 2010 - 05:57 PM

View PostEric 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.
Proud Cookbook author, though still learning powerful Yii! :] See my generic profile for more information. Cheers!
0

#24 User is offline   Trejder 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,197
  • Joined: 06-October 10
  • Location:Southern Poland

Posted 14 December 2010 - 09:36 AM

View Postqiang, 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.
Proud Cookbook author, though still learning powerful Yii! :] See my generic profile for more information. Cheers!
0

#25 User is offline   StErMi 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 259
  • Joined: 30-March 09

Posted 15 December 2010 - 06:17 AM

Can someone do a comparative with also PostgreSQL ?
0

#26 User is offline   samdark 

  • Having fun
  • Yii
  • Group: Yii Dev Team
  • Posts: 3,788
  • Joined: 17-January 09
  • Location:Russia

Posted 15 December 2010 - 12:14 PM

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

Enjoying Yii? Star us at github: 1.1 and 2.0.
0

#27 User is offline   StErMi 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 259
  • Joined: 30-March 09

Posted 15 December 2010 - 01:42 PM

View Postsamdark, 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
0

#28 User is offline   Trejder 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,197
  • Joined: 06-October 10
  • Location:Southern Poland

Posted 17 December 2010 - 05:07 AM

View PostStErMi, 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! :])
Proud Cookbook author, though still learning powerful Yii! :] See my generic profile for more information. Cheers!
0

#29 User is offline   beatyale 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 15-January 11

Posted 16 January 2011 - 12:00 AM

This is a great site.
0

#30 User is offline   Leric 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 36
  • Joined: 12-December 08
  • Location:Bejing, China

Posted 02 March 2011 - 08:36 AM

Yet another proof of the power of Yii
Unfortunately no one can be told what Leric is - you have to see him for yourself.
0

#31 User is offline   koloale 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 23-March 11

Posted 07 April 2011 - 03:18 AM

Is RealSelf.com is open source?
0

#32 User is offline   samdark 

  • Having fun
  • Yii
  • Group: Yii Dev Team
  • Posts: 3,788
  • Joined: 17-January 09
  • Location:Russia

Posted 07 April 2011 - 07:23 AM

No.
Yii 1.1 Application Development Cookbook

Enjoying Yii? Star us at github: 1.1 and 2.0.
0

#33 User is offline   adiasen 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 6
  • Joined: 16-March 11
  • Location:Germany

Posted 09 April 2011 - 02:00 PM

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
No risk no fun!
0

#34 User is offline   Kinetik 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 11
  • Joined: 22-June 11
  • Location:East Java, Indonesia

Posted 22 June 2011 - 10:45 AM

Wow. Great performance!
Congratulation on your project!
-= Good things come to those who wait =-
0

#35 User is offline   omarxp 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 17
  • Joined: 12-February 10
  • Location:Yogyakarta

Posted 07 September 2011 - 06:54 AM

wow, cool. B)
0

#36 User is offline   Mike Chojnacki 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 15
  • Joined: 31-January 12

Posted 13 February 2012 - 08:38 AM

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

edit*
0

#37 User is offline   g0dspeed 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 5
  • Joined: 05-July 12

Posted 05 July 2012 - 02:38 PM

Lol nice performance. Nothing in comparable to drupal lol :mellow:
0

#38 User is offline   gear 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 5
  • Joined: 22-December 11

Posted 27 September 2012 - 06:40 PM

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

#39 User is offline   jackjermey 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 5
  • Joined: 01-October 12
  • Location:London

Posted 02 October 2012 - 09:35 AM

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.
0

#40 User is offline   jeapie 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 10
  • Joined: 20-May 13

Posted 20 May 2013 - 01:11 PM

Really nice performance with this load
0

Share this topic:


  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users