[JIRA] Created: (MYO-111) Implement pass-through mode

[Gilles Rayrat (JIRA)]

Implement pass-through mode
---------------------------

Key: MYO-111
URL: https://forge.continuent.org/jira/browse/MYO-111
Project: Tungsten Connector
Type: New Feature

Components: MySQL protocol
Reporter: Gilles Rayrat
Assigned to: Gilles Rayrat
Fix For: 0.6.8


The connector speed could be greatly improved by streaming results directly from server to client, bypassing the jdbc resultset construction
Each executeQuery call would be affected: connector would use jdbc mysql input/output streams to send the query and stream answers back to the client application

[Gilles Rayrat (JIRA)]

[ https://forge.continuent.org/jira/browse/MYO-111?page=comments#action_15873 ]

Gilles Rayrat commented on MYO-111:
-----------------------------------

First results:

These numbers are, in percent, the performance gain (100 means "2 times
faster")


RSLRS RSS RSS2 WSS WMS WS
255.36 139.38 144.56 103.65 137.77 104.48
262.5 234.41 140.91 102.04 103.28 106.84
262.5 266.38 144.53 106.83 101.88 106.72
x 144.61 108.29
x x 108.2
x x 106.99

For the record:
RSLRS=ReadSimpleLargeResultsScenario
RSS=ReadSimpleScenario
RSS2=ReadSimpleScenario2
WSS=WriteSimpleScenario
WMS=WriteSimpleScenario_MYSQLREP
WS=WriteSimpleScenario_SLONY

Post by Gilles Rayrat (JIRA)
Implement pass-through mode
---------------------------
Key: MYO-111
URL: https://forge.continuent.org/jira/browse/MYO-111
Project: Tungsten Connector
Type: New Feature
Components: MySQL protocol
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.8
The connector speed could be greatly improved by streaming results directly from server to client, bypassing the jdbc resultset construction
Each executeQuery call would be affected: connector would use jdbc mysql input/output streams to send the query and stream answers back to the client application

[Edward Archibald (JIRA)]

[ https://forge.continuent.org/jira/browse/MYO-111?page=comments#action_15875 ]

Edward Archibald commented on MYO-111:
--------------------------------------

Note: The last commit included some code that, along with other related code, should be optimized. As it currently is written, we check, for every query, whether or not we can get access to an underlying MySQL io buffer and, also, we actually use Java reflection to get the io buffer for each query. It would not be too hard to do this during an initial 'connect' and to keep a reference to the io buffer for the life of the connection. This should be done as an overall part of the cleanup of this code.

Post by Gilles Rayrat (JIRA)
Implement pass-through mode
---------------------------
Key: MYO-111
URL: https://forge.continuent.org/jira/browse/MYO-111
Project: Tungsten Connector
Type: New Feature
Components: MySQL protocol
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.8
The connector speed could be greatly improved by streaming results directly from server to client, bypassing the jdbc resultset construction
Each executeQuery call would be affected: connector would use jdbc mysql input/output streams to send the query and stream answers back to the client application

[Robert Hodges (JIRA)]

[ https://forge.continuent.org/jira/browse/MYO-111?page=all ]

Robert Hodges resolved MYO-111:
-------------------------------

Resolution: Fixed

This is released to customers, hence resolved.

Post by Gilles Rayrat (JIRA)
Implement pass-through mode
---------------------------
Key: MYO-111
URL: https://forge.continuent.org/jira/browse/MYO-111
Project: Tungsten Connector
Type: New Feature
Components: MySQL protocol
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.8
The connector speed could be greatly improved by streaming results directly from server to client, bypassing the jdbc resultset construction
Each executeQuery call would be affected: connector would use jdbc mysql input/output streams to send the query and stream answers back to the client application