High volume site, benchmarking
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- /Kindest regards,/ *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com Signature <http://goodnewsdesign.com>
This probably isn't the place to talk about high performance, but http://groups.drupal.org/high-performance is the place. There is also a new book on Drupal performance coming out right about now, and lots and lots of blog posts and videos, etc. And a small group of companies that specialize in consulting in this area. -Randy On Wed, Jul 28, 2010 at 6:38 AM, Dayton Perkins <perkinsd@chartermi.net>wrote:
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- *Kindest regards,* *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com [image: Signature] <http://goodnewsdesign.com> <http://goodnewsdesign.com>
-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450
Hi What is the name of the book? Gordon Sent from my iPhone On 28/07/2010, at 10:43 PM, Randy Fay <randy@randyfay.com> wrote: This probably isn't the place to talk about high performance, but http://groups.drupal.org/high-performance is the place. There is also a new book on Drupal performance coming out right about now, and lots and lots of blog posts and videos, etc. And a small group of companies that specialize in consulting in this area. -Randy On Wed, Jul 28, 2010 at 6:38 AM, Dayton Perkins <perkinsd@chartermi.net>wrote:
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- *Kindest regards,* *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com
http://www.amazon.com/Drupal-Performance-Tips-Trevor-James/dp/1847195849 Looks like it's pretty well panned by the first reviewer, though. Again, the high performance group is a great place to start. -Randy On Wed, Jul 28, 2010 at 6:46 AM, Gordon Heydon <gordon@heydon.com.au> wrote:
Hi
What is the name of the book?
Gordon
Sent from my iPhone
On 28/07/2010, at 10:43 PM, Randy Fay <randy@randyfay.com> wrote:
This probably isn't the place to talk about high performance, but
<http://groups.drupal.org/high-performance> http://groups.drupal.org/high-performance
is the place. There is also a new book on Drupal performance coming out right about now, and lots and lots of blog posts and videos, etc. And a small group of companies that specialize in consulting in this area.
-Randy
On Wed, Jul 28, 2010 at 6:38 AM, Dayton Perkins < <perkinsd@chartermi.net> perkinsd@chartermi.net> wrote:
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- *Kindest regards,* *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 <http://goodnewsdesign.com>http://goodnewsdesign.com
-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450
I read that, and personally think your money is best saved on that book. Also, check out Mercury - it tries to give you out-of-the-box high performance Drupal. http://getpantheon.com/mercury/what-is-mercury <http://getpantheon.com/mercury/what-is-mercury> http://groups.drupal.org/pantheon <http://groups.drupal.org/pantheon>Justin On Wed, Jul 28, 2010 at 7:58 AM, Randy Fay <randy@randyfay.com> wrote:
http://www.amazon.com/Drupal-Performance-Tips-Trevor-James/dp/1847195849
Looks like it's pretty well panned by the first reviewer, though.
Again, the high performance group is a great place to start.
-Randy
On Wed, Jul 28, 2010 at 6:46 AM, Gordon Heydon <gordon@heydon.com.au>wrote:
Hi
What is the name of the book?
Gordon
Sent from my iPhone
On 28/07/2010, at 10:43 PM, Randy Fay <randy@randyfay.com> wrote:
This probably isn't the place to talk about high performance, but
<http://groups.drupal.org/high-performance> http://groups.drupal.org/high-performance
is the place. There is also a new book on Drupal performance coming out right about now, and lots and lots of blog posts and videos, etc. And a small group of companies that specialize in consulting in this area.
-Randy
On Wed, Jul 28, 2010 at 6:38 AM, Dayton Perkins <<perkinsd@chartermi.net> perkinsd@chartermi.net> wrote:
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- *Kindest regards,* *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 <http://goodnewsdesign.com>http://goodnewsdesign.com
-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450
Look through the case studies on the drupal.org home page, there are plenty that are huge and respond well. On Jul 28, 2010, at 8:38 AM, Dayton Perkins wrote:
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- Kindest regards, Dayton Perkins Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com <animatedlogo.gif>
Hi Basically the best place to start is pressflow and varnish And the a lot of tweaking Gordon Sent from my iPhone On 28/07/2010, at 10:38 PM, Dayton Perkins <perkinsd@chartermi.net> wrote: I am talking with a client about redoing a site in Drupal that gets millions of page views monthly. My concern is page generation time. I would need to assure my client that I con produce pages very fast. Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would like some input on getting started in the world of benchmark testing. (I know you probably need to install dev) :-) Thank you for your input. -- *Kindest regards,* *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dayton Perkins schrieb:
I am talking with a client about redoing a site in Drupal that gets millions of page views monthly.
How much is "millions"? 1-3? 5-10? 100-200?
My concern is page generation time. I would need to assure my client that I con produce pages very fast.
That depends on the complexity of your pages. And on things like hardware setup. And how fast is "very fast" anyway?
Here are a couple of questions: I don't think my question will be MySql vs. Postgre, but I would
No, you should use MySql anyway. It is hard to find people who can advise you on tuning your Postgre setup. Cheers, Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAkxQK5gACgkQfg6TFvELooQS2ACfaJYzRtOwqvM8im9HN4LIwThm 9lEAn3PVhzH8v2cX+COeyyPzGqQwunCM =AJbA -----END PGP SIGNATURE-----
participants (6)
-
Dayton Perkins -
Gerhard Killesreiter -
Gordon Heydon -
Justin Ellison -
Ken Winters -
Randy Fay