If I am using mysql and php to build a db driven site, wat wud be the optimal range before i have problems?

Question

me and my team are doing it for the queens chamber of commerce.

we have to design a website which will cater to high school and college students who want internships and employment, specifically in new york city and around the triboro area.

we have already tested a beta version in mysql and php and its promising.

nyc has a population of about 8 million, lets say 3 million are students, and 1.2 million are in high school + college in and around the city. if can get 1.2 million users how much would that affect the overall performance of the backend?

my supervisor wants to use java and postresql.

what is your opinion?

thank you so much

Answer 1

If you write a Java applet that connects to your database remotely, the bandwidth usage will probably go sky high for 25% load reduction on the database, compared to a server side design.

If you require optimization, you can..
- create indexes
- cache the indexes ( http://dev.mysql.com/doc/refman/5.1/en/cache-index.html )
- possibly upgrade RAM if not enough to cache all indexes without swapping
- optimize SQL requests
- You could consider splitting your database on multiple machines for load balancing.

Answer 2

You may have 1.2 million potential visitors, but it's not like all 1.2 million are going to be viewing the page at the same time.

Take strain off your server by using compression and caching and simulate heavy server load by using a program such as Microsoft Application Test Center.

Here's a link for some other application load testers:

http://www.softwareqatest.com/qatweb1.html

Answer 3

I thank god to have given me 2 healthful legs to stroll,2 hands to do our daily artwork and to help others,2 eyes to make certain,2 ears to take heed to exact,a eye-catching face to be well known my people,a competent heart to love people and be have been enjoyed,a competent physique altogether,stable nutrition to consume,a glance after to guard ourselves from rain,wind,solar,winter...stable parents who offered us up and blessed us to have stable life,a brother who taught me what life is,a competent husdand's kinfolk and a spectacular hubby,stable circle of pals too and quite some greater... I thank god to have given an threat to thank all who're particular of their own way.. I thank god that he felt i deserve a splash area is his feet to tutor how lots iam linked to him and his advantages thank you Jinku