[GitHub] [incubator-shardingsphere] HongJinFeng opened a new issue #3676: Is there any good way to handle with parsing sql first time, which is taking too many time?

[GitBox <gi...@apache.org>]

HongJinFeng opened a new issue #3676: Is there any good way to handle with parsing sql first time, which is taking too many time?
URL: https://github.com/apache/incubator-shardingsphere/issues/3676
 
 
   Hi, we use encrypt-jdbc in our project, and last night we released it to production environment，when it started at the first time, our dubbo interface had many delay warings. After my investigation, it was because parse sql took too many time, most of them took more than one second, some beyond one second. And in this situation, our interface already time out, and it may cause dubbo create too many thread to handle retry consumers, then the program may crash(our project has more than 500 thousand requests per minute ). 
   
   Although i had warm up some interface to cache sql statement, but the problem still exist. So, it there any good way to deal with it？I tell my leader if can add the sql statement to redis,and every time the program start , i load it to local memory. But, he deny it, with the reason that the module(which i package sharding-core, fix some bug, and add some features) must with less dependencies. So i am very anxious, please help me, it there any good way to deal with this problem.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services