title: Will an application on PHP Yii framework with MySQL database handle an ERP solution of 20K employees?
body: <p>We have got a project to build an ERP system for one of the largest garment industry of Bangladesh.  </p>
  
  <p>They have around 20,000 employees and about 10% of them get out/in every month. We are a small company with 5 PHP developers and don't have much experience with such a large project. We have developed different small/medium scale projects previously with Codeigniter/Zend Framework and MySQL database.  </p>
  
  <p>For this project we decided to go with Yii framework and MySQL or PostgreSQL. There will be about 1 million database query every day. Now my question is can MySQL/PostgreSQL handle this load or is there a better alternative? Is it ok to do it with Yii framework or there have a better PHP framework for this kind of application? We have got only 5 months to build the payroll and employee management modules.</p>