MariaDB database VIEW support

[Fulliton]

In a large project, where more than 4,000 DBMS requests occur per second, it was decided to implement a view to avoid a pile of program code. In short, to get a list of certain entities, we had to run to 7 adjacent tables with checks for pivot data.

In general, I implemented the view.

select * from device_clients_view where client_id = 1

took 0.001 seconds already, compared to a large select compiled via ORM

But when executing this sql query through Laravel, the execution speed was reached up to an unthinkable 500-2000 milliseconds

The solution was found after 8 hours of code raking in laravel -> Database

As a result, after thousands of attempts, having identified the problem in the PDO settings, it was decided that in order to speed up the response to a speed close to the CLI, it is necessary to turn off options in config/databases

PDO::ATTR_EMULATE_PREPARES => true