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/11/07 01:40:56 UTC
[GitHub] [shardingsphere] mintheon opened a new issue, #21981: After program starts, the first execution of sql is too slow
mintheon opened a new issue, #21981:
URL: https://github.com/apache/shardingsphere/issues/21981
I use Sharding-jdbc 5.1.1.
I used a different version(5.2.0) just in case, but it's the same.
After program starts, the first execution of sql is too slow, It takes me 3 seconds, but it takes me up to 6 seconds to read other people's comments.
The picture above is a profile of the moment that takes 3 seconds. Sharding Spear Class uses about 1.6s.
<img width="1749" alt="image" src="https://user-images.githubusercontent.com/23326757/200209416-eeda4b03-a89b-4592-81f3-bf293f1ca405.png">
--
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] mintheon commented on issue #21981: After program starts, the first execution of sql is too slow
Posted by GitBox <gi...@apache.org>.
mintheon commented on issue #21981:
URL: https://github.com/apache/shardingsphere/issues/21981#issuecomment-1308966034
> On the other hand, JVM need to be warmed up to optimize performance.
thx. I solved it by inserting the JVM WarmUp logic.
By the way, are other people's issues the same? -> 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] TeslaCN commented on issue #21981: After program starts, the first execution of sql is too slow
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21981:
URL: https://github.com/apache/shardingsphere/issues/21981#issuecomment-1305028512
On the other hand, JVM need to be warmed up to optimize performance.
--
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 #21981: After program starts, the first execution of sql is too slow
Posted by GitBox <gi...@apache.org>.
mintheon commented on issue #21981:
URL: https://github.com/apache/shardingsphere/issues/21981#issuecomment-1308965718
@TeslaCN
thx. I solved it by inserting the JVM WarmUp logic.
By the way, are other people's issues the same? -> #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] TeslaCN commented on issue #21981: After program starts, the first execution of sql is too slow
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21981:
URL: https://github.com/apache/shardingsphere/issues/21981#issuecomment-1305025620
It seems that there were some overheads related to datadog.
--
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] sandynz closed issue #21981: After program starts, the first execution of sql is too slow
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #21981: After program starts, the first execution of sql is too slow
URL: https://github.com/apache/shardingsphere/issues/21981
--
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