Joomla! Discussion Forums

Yesterday i was told by some guys trying to sell me some file-base CMS that CMS based on MySQL can not work with a great number of users daily, that 50 simultaneous requests may down a site.
What do think?

Bs...  It's all dependant on your configuration and hardware.  Given proper setup a single server can serve hundreds of simultaneous users (I have a single server that serves an estimated 2000 simultaneous users)...

The biggest Joomla! site I know that is being build will handle 40 million pagehits per day...and has a massive infrastructure underneith it. Yes, the infrastructure limits what you want...but 50 connections is no big deal.

if it's the site I am thinking of, it's being built off the framework, right?  Not the CMS?

Yes...but remember that the CMS also uses that framework ;-)

Oh, I'm not saying anything about that, but I was just wondering if we were thinking of the same project...

I think we're thinking of the same project, but that should read "40 million pageviews weekly"

Just a minor difference, but still a lot 

It's a factor of 7, but at these volumes, does it really matter?

was wondering could any of you just give some examples of joomla sites with a million visitors or more a month?

For advocacy purposes a list of such sites would be a really smart move - and a valuable resource. I'll be making lots of noise when this project I'm working on goes up for good, right now it is in beta mode and still needs some additional features before the official unveiling.

There are many sites out there, unfortunately my scatterbrained memory is not assisting in the assembly of such a list. I remember there was a site born to help survivors of hurricane Katrina, and it went on to become a much bigger site, That might have been the highest traffic Joomla site on the 'Net, but am not so sure.

Even the Joomla.org sites get that much traffic, I wager. Don't they, Brad?

Godaddy states in two places that the limit on MySqL concurrent users is 50 but, I believe the number is actually 500.

Ok, but 500 still doesn't seem like a lot if you are trying to build a truly massive site.  So what happens after that threshold?  Are you stuck?  What would be the next step?

Maybe that's referring to a shared MySql server that GoDaddy sells, because that seems really low. If that's the case, the next step would be to upgrade to a better hosting plan.

500 being low?!?!?!!?!?!?!?!!?  How?

Ok, let's look at 50 connections.

Your average web page takes < 2 seconds to generate, but let's say 5 seconds.  Some simple math says 50 connections can support 10 connections per second.  That's 10 requests per second.  That's 600 req/min, or 36000 req/hour, or 864000 req/day.  That's NOT hits, that's php requests alone...

If you're doing almost a million page views per day, you should NOT, SHOULD NOT be on a shared server.  Period.  That's the realm of dedicated servers (possibly multiple)...

Heh, whoops...I meant to refer to the quote above instead.

But it sounds like your response still applies. I didn't realize 50 connections would be that resource intensive because I was thinking of 50 connections being equal to 50 visitor sessions. But it sounds like I should be thinking of connections as being equal to a php request? Would that be accurate?? 

Yup... a connection is used for exactly one php request...