MySqlConnector icon indicating copy to clipboard operation
MySqlConnector copied to clipboard

Handle explicit MySqlDbType for prepared statements more efficiently

Open bgrainger opened this issue 6 years ago • 0 comments
trafficstars

For #659 the fix in ce16109522bf4adb93f231b401b9aa150af31ad4 ignored all explicit MySqlParameter.MySqlDbType values and just used the inferred type from MySqlParameter.Value.GetType(). This is probably needlessly inefficient, in terms of runtime performance, and number of bytes on the wire (e.g., if an int typed as MySqlDbType.Short could be sent as two bytes, not four).

Investigate if there's an efficient way to respect MySqlParameter.MySqlDbType when serializing binary parameters.

bgrainger avatar Jun 25 '19 23:06 bgrainger