#4409 - Merge SET commands for MySQL connection
-
By Chris Graham
- Added
- 1 view
| Identifier | #4409 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Merge SET commands for MySQL connection |
| Status | Completed |
| Tags |
Type: Performance (custom) |
| Handling member | Chris Graham |
| Addon | core_database_drivers |
| Description | When connecting to MySQL, Composr will do some number of SET commands to set an expected connection environment (charset, collation, timeouts, compatibility).
MySQL supports doing multiple SETs at once. One SET is taking 0.016 ms on my machine (i.e. very little). However, in a live environment there could certainly be more latency, esp if the database machine is not the same machine as the web server. I am concerned if one SET fails, they all might, or ones further in the group of SETS might - this needs investigating. What happens, and what SET might fail? |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
There have been no comments yet