You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/06/15 03:25:26 UTC
[GitHub] [shardingsphere] SmallBeautifulPig opened a new issue, #18369: After the program starts, the first execution of sql is very slow
SmallBeautifulPig opened a new issue, #18369:
URL: https://github.com/apache/shardingsphere/issues/18369
when use sharding-jdbc 5.1.1
After the program starts, the first execution of sql is very slow, it takes about 5-6 seconds.
I can't find a reasonable configuration from the official website to solve 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1272349617
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mintheon commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
mintheon commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1304839908
me too!
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wszpwsren commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
wszpwsren commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1155973319
same
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] csonezp commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1182871108
I want to try it
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #18369: After the program starts, the first execution of sql is very slow
URL: https://github.com/apache/shardingsphere/issues/18369
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1159476365
What is the SQL details, can you use APM tools to locate the SQL parse and execute spend?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1159483438
The SQL need to be parsed to AST for 1st received and will put into cache.
SQL warm up feature can let user indicated SQLs before the application start-up.
If anyone want to do it, we can discuss the desgin.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jsgjj111 commented on issue #18369: After the program starts, the first execution of sql is very slow
Posted by GitBox <gi...@apache.org>.
jsgjj111 commented on issue #18369:
URL: https://github.com/apache/shardingsphere/issues/18369#issuecomment-1156170466
me too...
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org