Download the PHP package huy-nguyen/laravel-optimize-init-db-connection without Composer
On this page you can find all versions of the php package huy-nguyen/laravel-optimize-init-db-connection. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download huy-nguyen/laravel-optimize-init-db-connection
More information about huy-nguyen/laravel-optimize-init-db-connection
Files in huy-nguyen/laravel-optimize-init-db-connection
Package laravel-optimize-init-db-connection
Short Description A package for optimize Laravel init database connection
License MIT
Homepage https://github.com/huy-nguyen/laravel-optimize-init-db-connection
Informations about the package laravel-optimize-init-db-connection
This package for optimize Laravel Init Database Connection
As mentioned in PR 50044, this package was implemented for lower Laravel version (PHP >= 7.2, Laravel >= 6)
"The current code does multiple round-trips to set all the variables we need for our config, both because there are multiple commands to run, but also because it's using prepare, for many of them - each use of prepare and execute causes 3 round trips - one to prepare, one to execute, and one to close statement (on garbage collection of the statement in PHP land). The MySQL SET command supports setting multiple things in a comma separated fashion. Refactoring to do this enables us to just run one SET statement against the server. This can make a real difference in a cloud situation such as AWS Lambda talking to an RDS database where we have to go cross-AZ with low single digit ms latency, instead of sub-ms latency. This also reduces load on the DB (fewer statements to execute), so spinning up a bunch of Lambdas in a burst will be less of a burden."
Installation
You can install the package via composer:
You can publish the config file with:
This is the contents of the published config file:
Usage
As default, this package will change your "mysql" connection. You can setup new database connection by:
Change your configuration ()
Update your driver connection to :
Testing
Changelog
Please see CHANGELOG for more information on what has changed recently.
Contributing
Please see CONTRIBUTING for details.
Security Vulnerabilities
Please review our security policy on how to report security vulnerabilities.
Credits
- huynt57
- All Contributors
License
The MIT License (MIT). Please see License File for more information.