19 Star 33 Fork 26

openLooKeng / hetu-odbc-driver

 / 详情

reduce message exchange with DB Server in SQLStatement executing process

Done
Task
创建于  
2020-09-28 11:27

Software Environment:
OpenLooKeng version (source or binary): NA

OS platform & distribution (eg., Linux Ubuntu 16.04): NA

Java version:

Describe the current behavior
when executing SQL statement(select/insert/delete/update) with ODBC API, the default process of openLooKeng driver is executing MySQL c/s binary message with openLooKeng server, that is COM_PREPARE + COM_EXECUTE. As we use gateway to act as a server agent and gatewat is written in JAVA with JDBC, COM_PREPARE is then devided into 5 message exchange stages with openLooKeng server.(the stages are as below: prepare statement + describe input statementId + describe output statementId + deallocate statementId).
These are very heavy call process, and performance will be delayed heavily in low network env(gateway<--->openLooKeng server). Network workload is also heavy in this work mode.

Describe the expected behavior
When executing SQLstatements with no input parameters, driver sends COM_QUERY message instead of COM_PREPARE+COM_EXECUTE, in this way gateway need only one JDBC cmd exchange with openLooKeng server.
We can observe the difference with openLooKeng server's web page in which shows commands.

Steps to reproduce the issue
same as expected behavior

Related log/screenshots
NA

Special notes for this issue
NA

评论 (0)

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(1)
C
1
https://gitee.com/openlookeng/hetu-odbc-driver.git
git@gitee.com:openlookeng/hetu-odbc-driver.git
openlookeng
hetu-odbc-driver
hetu-odbc-driver

搜索帮助