Can you give a little advice on using Doctrine dbal, is it worth using it at all?

Recently did tests for query performance
MYSQLi (Standart) and Doctrine dbal (MYSQLi Driver). Tests surprised me a little.

It is on the local

  • Doctrine dbal → 100,000 executed for 73.257080078125
  • MYSQLi (Standart) → 100,000 executed for 22.825722932816

On server

  • Doctrine dbal → 100,000 requests executed for 65.95
  • MYSQLi (Standart) → 100,000 queries executed for 19.32

  • Doctrine dbal → 10,000 requests executed for 7.8542101383209
  • MYSQLi (Standart) → 10,000 queries executed for 2.6818990707397

    2 answers 2

    Doctrine dbal whether to use

    When deciding on the use of a driver, the number of requests is unlikely to be taken into account. The execution time of the request is clearly in an adequate backend will not depend on the driver, but on the fullness of the database, the type of database, and the complexity of the requests. How gracefully requests are made is what matters most, how safe and easy it is for a programmer to work with them. Therefore, I will answer the question:

    Of course it is. mysqli is not too OOP shny, leaves the possibility of triskodit and make security holes.

      Doctrine dbal - I read its documentation, it seems they did everything perfectly there, I was just surprised by the time to execute queries, because of this.