Bug #68804 | Very Slow Network Performance | ||
---|---|---|---|
Submitted: | 28 Mar 2013 16:01 | Modified: | 3 Apr 2013 10:28 |
Reporter: | Moises Soto | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | Connector / ODBC | Severity: | S5 (Performance) |
Version: | 5.2.4w | OS: | Windows (Windows 7 Enterprise) |
Assigned to: | Bogdan Degtyariov | CPU Architecture: | Any |
[28 Mar 2013 16:01]
Moises Soto
[3 Apr 2013 10:28]
Bogdan Degtyariov
Hi Moises, Thanks for your interest in MySQL software. Unfortunately, your suggestion to increase size of the network packets cannot be implemented within the current architecture of MySQL Network protocol, which is a one-way street. Sending a new command to the server without reading the server's response results in an error (Commands out of sync). You can increase the network efficiency by using batched queries (sending several SQL statements at once). For instance, the following call sends two SELECTs at once and the server returns two result sets at once: SQLExecDirect(hstmt, "SELECT * FROM tab1; SELECT * FROM tab2", SQL_NTS); Also, for INSERT statements you can do several records at a time as: INSERT INTO tab1 (col1, col2) VALUES (1, 1), (2, 2), (3, 3), (4, 4); There is no plans to change the behavior you observe. So, with all regret I must set the status "Won't fix" for this bug report.