View Issue Details

Jump to NotesJump to HistorySearch commits
IDProjectCategoryView StatusDate SubmittedLast Update
0004409Composrcore_database_driverspublic2020-10-05 19:182020-10-07 03:09
ReporterChris GrahamAssigned ToChris Graham 
SeverityFeature-request 
Status resolvedResolutionfixed 
Product Version 
Fixed in Version 
Summary0004409: Merge SET commands for MySQL connection
DescriptionWhen 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?
TagsType: Performance
Time estimation (hours)1.2
Sponsorship open

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-10-05 19:18 Chris Graham New Issue
2020-10-05 19:18 Chris Graham Tag Attached: Type: Performance
2020-10-07 03:09 Chris Graham Assigned To => Chris Graham
2020-10-07 03:09 Chris Graham Status non-assigned => resolved
2020-10-07 03:09 Chris Graham Resolution open => fixed