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/08/22 19:14:19 UTC

[GitHub] [shardingsphere] silversteak opened a new issue, #20431: Limit metadata loading to specific configured Single Tables only

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

   In GenericSchemaBuilder, I see that apart from the sharding tables all other tables meta data is getting loaded. Is it possible to limit that to specific configured Single Tables only. As my micro services needs only few tables out of 420 tables to get loaded. This will drastically boast the loading time of the service. 
   
   ![image](https://user-images.githubusercontent.com/25997886/186000360-17d3b274-cdf1-4ab4-93b7-82c270f00d71.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] silversteak commented on issue #20431: Limit metadata loading to specific configured Single Tables only

Posted by GitBox <gi...@apache.org>.
silversteak commented on issue #20431:
URL: https://github.com/apache/shardingsphere/issues/20431#issuecomment-1331659626

   @terrymanu @TeslaCN can you please have a look into 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] mouaifulao commented on issue #20431: Limit metadata loading to specific configured Single Tables only

Posted by GitBox <gi...@apache.org>.
mouaifulao commented on issue #20431:
URL: https://github.com/apache/shardingsphere/issues/20431#issuecomment-1316432251

   There are more than 1000 tables in our test environment, they belong to one Oracle schema.
   The application took 30 minutes to start, and most of the time was spent on loading schemedata for single tables.
   We just have 22 sharding tables, and most signle tables are not associated with these sharded tables.
   Is there any way to load table metadatas  just for the sharded tables and the associated siginle tables?
   


-- 
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] Limit metadata loading to specific configured Single Tables only [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #20431: Limit metadata loading to specific configured Single Tables only
URL: https://github.com/apache/shardingsphere/issues/20431


-- 
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] commented on issue #20431: Limit metadata loading to specific configured Single Tables only

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20431:
URL: https://github.com/apache/shardingsphere/issues/20431#issuecomment-1272348774

   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] strongduanmu commented on issue #20431: Limit metadata loading to specific configured Single Tables only

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #20431:
URL: https://github.com/apache/shardingsphere/issues/20431#issuecomment-1331671847

   @silversteak Thank you for your feedback, we are designing a new single table loading logic. By default, no single table is loaded. Users can specify which single tables to load through YAML or DistSQL.


-- 
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 #20431: Limit metadata loading to specific configured Single Tables only

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20431: Limit metadata loading to specific configured Single Tables only
URL: https://github.com/apache/shardingsphere/issues/20431


-- 
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] Calabor-Hoc commented on issue #20431: Limit metadata loading to specific configured Single Tables only

Posted by GitBox <gi...@apache.org>.
Calabor-Hoc commented on issue #20431:
URL: https://github.com/apache/shardingsphere/issues/20431#issuecomment-1329473067

   I have the same concern. 
   Loading all table metadata also brings another problem to me:
   Oracle UROWID cannot be parsed by shardingsphere, which leads to NPE during boot.
   


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