childewuque commented on issue #10938:
URL:
https://github.com/apache/shardingsphere/issues/10938#issuecomment-988615412
> @childewuque Can you help to position the code which is slow?
Thanks for the quick response!
1.There are about 6000 tables in every DB. But only one logic table named
prod_score is sharded in my project.
2.actualDataNodes:
dataSource$->{1..4}.prod_score_$->{(Integer.toHexString(0)..Integer.toHexString(255)).collect{t
->t.padLeft(2,'0')}}
3.The slowest point is the line in SingleTableMetaDataBuilder.load() --line
51：
Collection<TableMetaDataLoaderMaterial> tableMetaDataLoaderMaterials =
TableMetaDataUtil.getTableMetaDataLoadMaterial(needLoadTables, materials,
false);
Because there are about 24000 tables in Collection<String>
needLoadTables.
Now my solution is that all tables are configed at actualDataNodes for
exclude ,but it is toooooo long.
Thanks.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
