Multiple Database Connection per Request

[mitelg]

At the moment, we build up multiple data connection to MySQL.
This lead to too many connections and moreover an overhead for building up the connections.

Instead of creating a connection with

• PDO in the Kernel
• DBAL in the services.xml
• Shopware_Plugins_Backend_Auth_Bootstrap::createSaveHandler

We should just use only one of these.

[mitelg]

the first one is in the DI container as "db_connection" and is a PDO connection. the second is the "dbal_connection" and is a DBAL connection. so those two could not be unified, as this would result in a break. because the services behave not the same and have different methods.

the connection in the auth plugin is also a PDO connection, which may be used with the one, created in the kernel. but I don't know if this was done on purpose because of session locking?

possible solution: using the PDO connection from the kernel, to create the DBAL connection

[kayaArvatis]

@mitelg I think the current implementation was due session locking i remember we had some problems with it caused by a plugin