You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "13145512239 (via GitHub)" <gi...@apache.org> on 2024/08/05 01:26:50 UTC

[I] slow sql [shardingsphere]

13145512239 opened a new issue, #32399:
URL: https://github.com/apache/shardingsphere/issues/32399

   ## Question
   
   Hi,I use shard 5.2.0,and i find a question,when i first query database,oracle or mysql,it will spend more time,how do i fix this?
   


-- 
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


Re: [I] slow sql [shardingsphere]

Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #32399:
URL: https://github.com/apache/shardingsphere/issues/32399#issuecomment-2268049230

   I would say this is essentially caused by shardingsphere querying the database metadata. If you are using spring boot, you can set up a spring bean of `org.springframework.boot.ApplicationRunner`, which uses shardingsphere jdbc datasource to execute a statement like `SELECET 1`. The verification SQL for each database is different, and the verification SQL has nothing to do with the database gateway of shardingsphere.


-- 
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


Re: [I] slow sql [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #32399: slow sql
URL: https://github.com/apache/shardingsphere/issues/32399


-- 
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


Re: [I] slow sql [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #32399:
URL: https://github.com/apache/shardingsphere/issues/32399#issuecomment-2268109261

   The title of this issue is not well enough, could you please update to a more understandable title by summarizing the content?


-- 
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


Re: [I] slow sql [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #32399:
URL: https://github.com/apache/shardingsphere/issues/32399#issuecomment-2297353378

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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