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/02/21 12:54:26 UTC

[GitHub] [shardingsphere] linxiaofan edited a comment on issue #15543: Sharding-JDBC 5.1.0 startup time is too long

linxiaofan edited a comment on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-1046816942


   >Sharding is too slow to load metadata. For example, if we have 10000 sub-tables, suppose each sub-table has 40 fields, Sharding executes the following SQL to load metadata.
   SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_KEY, EXTRA, COLLATION_NAME, ORDINAL_POSITION FROM information_schema.columns WHERE TABLE_SCHEMA='woven_clothinspect' AND TABLE_NAME IN ('');
   Information_schema. columns is not a table but a poorly performing view. Can this be resolved?Our production environment encountered this serious problem of slow startup
   
   


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