Will a PHP Yii-based application with a MySQL database handle an ERP solution of 20K employees?

Question

We have a project to create an ERP system for one of the largest sewing enterprises in Bangladesh.

They have about 20,000 employees, and about 10% of them receive / every month. We are a small company with 5 PHP developers and do not have much experience working with such a large project. Previously, we developed various small and medium scale projects using the Codeigniter / Zend Framework and the MySQL database.

For this project, we decided to go with the Yii framework and MySQL or PostgreSQL. About 1 million database queries will be requested daily. Now my question is, can MySQL / PostgreSQL handle this load or is there a better alternative? Can this be done using the Yii framework, or do you have a better PHP framework for such an application? We only have 5 months to create payroll and employee management modules.

Answer 1

On the one hand, PostgreSQL should be used, not MySQL. You will be dealing with critical data and, in general, you will understand that:

• ( ), .
• , , , .
• (MyISAM), .
• ( ).

, , != . ; .

PHP Yii , , . , Symfony2 ( Symfony, - ) : -, .

Answer 2

, Yii () . Yii 1,3 , thausend .

, Yii .

. @Denis , . MySQL, , / .

, , Yii. :

-Yii - : (, ajax), : . .  : (HTML Forms). , Yii 1.1.6, HTML-, Yii 1.1.7, , . : Yii , "t". ! , ( ). MySql, , Yii "t". , MySql tablename, , . → , , PHP ( Yii). : , .

-Yii . . " " , , .

-Yii PHP 5.2. Yii 5.3, (Yii 5.3 - , ), 5.3 ( , ?) PHP5.3 () Yii 2.0 - (2012)

-Yii ( ) .

- ( , - - )

-Yii - OO PHP. , Data-Objects. . , ( ).

: Yii, , .

Answer 3

, , , .

ERP. :

• . .
• . , , ( , ).
• . .
• . , , .
• . , - , .
• . , , ..
• . , .

, - ​​ , ERP- . - , ORM , , SQL.

- , , 20K - .

, , , , PostgreSQL, , . Yii, . ORM, , .

, , ( JMeter ) , . - - , , , , , , .

Answer 4

, Yii (, ..) , ). , Yii, , , , , . Yii - gii, , .

Answer 5

Yii , PHP-.