Limits of PHP & Mysql ?

whn71 · 9th December 2003, 02:38 AM

I know that php/mysql environment is meant for small to medium projects, but I would like to know exactly what are the limits beyond them php/mysql can't do the job?

no_name · 9th December 2003, 07:56 AM

Where did you get that idea?

whn71 · 9th December 2003, 12:31 PM

That's according to the best of my knowledge:

php is for developing small to medium projects,
java is for the large ones.

if this is true I would like to know the borders beyond that php/sql doesn't fit and that is where java suitable.

sticky · 9th December 2003, 01:00 PM

These may be of help to you

http://www.sitepointforums.com/showt...ghlight=limits

http://www.mysql.com/doc/en/Table_size.html

Patch · 9th December 2003, 01:50 PM

Technically, PHP and MySQL should be fine for large projects, but many large corporations shun their use because they are open source. This means that, while some excellent support is available via a huge user community, corporate users cannot tie down the supplier with the usual support and maintenance contracts. Instead, these large users turn to DBMSs such as Oracle, where they believe the support will be better assured.

As Sticky's link shows, MySQL 3.23 supports a theoretical maximum table size of 8 million terabytes. This should be OK for most projects

Regards

Patch

whn71 · 10th December 2003, 01:54 PM

What about the number of concurrent users mysql can serve?

Is mysql always the bottle neck? php doesn't affect the project size?

UH-Matt · 10th December 2003, 02:06 PM

Before answering the question at hand you would have to define the difference between small, medium and large projects.

whn71 · 10th December 2003, 04:12 PM

I'm not exactly sure, A java programmer told me:

small project: million transcations year
medium project: milliona a month
large project: million a day

Is that right?

no_name · 10th December 2003, 07:36 PM

you should keep in mind that if you plan to have a large project you should also think of having a dedicated server for that site.

If you plan to host your sites on UH servers like rest of us

than you shouldn't be worried if mysql can handle it or not.