Business logic in PHP or MySQL?

Question

On a site with a reasonable amount of traffic, will it matter if the application / business logic is written as stored procedures, triggers and views, and not inside the PHP code itself?

What would be the best way to keep scalability in mind.

Answer 1

I can’t provide you statistics, but if you do not plan to change PHP for another language in the future, I can say that saving business logic in PHP is more “compatible with scalability”.

-, . . , .

Answer 2

, - PHP-, . , , , , .

, , .

Answer 3

PHP- , , , . , PHP, , ..

MySQL , PHP , , . .., - . MySQL , PHP- ( ), , PHP , , . , , "" MySQL, .

Answer 4

, , , . , , . dbs terrabyte .

, , .

Answer 5

, - , .

/- ? / ?

, , . , .. .. .

MySQL ? PHP? ?

. , , SQL, , . , ATOMIC. SQL ( MySQL) , , ..

PHP, , , , . , PHP- , , .

/ ?

, , .

, , - , , , . , , , , , , .

Answer 6

POV, , , - :

1 - , , , , PHP ,

2 - , , RDBMS, , SP, . -

3 - , , . , , RDBMS RDBMS, SP. , , .

4 - , - , - (, ), , , SP, -.

, , , , , . , , , SP - , . POV, .

Answer 7

MySQL , . PHP, , . PHP.