A question from Yahoo! Answers:
If I am using mysql and php to build a db driven site, wat wud be the optimal range before i have problems?
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?
Most of PHP application performance issues are caused by server settings. Rasmus Lerdorf, the creator of PHP, spoke at php|works conference in Toronto in September. During his address, he demonstrated an example of server optimization; an application went from handling 17 requests per second to handling 1,100 requests per second without any changes to the code, only by tweaking with Apache and MySQL settings…