too slow when application running,version:4.0.0-RC1

[Li-Turing]

application run slowly when i use default-datasource-name

shardingsphere will load shardingContext and connect to db,why do this?

there is much tables and colums, when shardingsphere do it,it is slow

my configuration:
check.table.matedata.enable:false

slow function:
loadDefaultTables()

@SneakyThrows
public Map<String, TableMetaData> load(final ShardingRule shardingRule) {
Map<String, TableMetaData> result = new HashMap<>();
result.putAll(loadShardingTables(shardingRule));
result.putAll(loadDefaultTables(shardingRule));
return result;
}

this function is slow

[Li-Turing]

@tristaZero

[tristaZero]

Hi, instead of loading the metadata from all of sharding tables and checking them,
check.table.matedata.enable:false will make Sharding Sphere only load the meta data from one sharding table and all tables from default data source. Because we need the metadata of sharding table.
So it is not a bug, but an optimization item. Please refer to #1951.
If you're interested in it, please try to do it.

[MidnightFiend]

with RC1 , i find it load all table in the pointed db, which is not configured in "logic-tables=user,order,...".

is there any way to optimize the problem?

[MidnightFiend]

i had try this way. it`s not work. still go to get all table column metadata.

<sharding:data-source id="shardingDataSource">
    <sharding:props>
        <prop key="check.table.metadata.enabled">false</prop>
    </sharding:props>
...

[Fermiz]

@tristaZero as you said, Sharding Sphere only load the meta data from one sharding table and all tables from default data source , when the tables from default data source are to many, it would take about 2 mins during application initialization, it's two slow for continuous deploying, is there any idea to extend or remove result.putAll(loadDefaultTables(shardingRule));? I saw a lot of issues are related to this, looking forward to it, thanks

[wephone]

check.table.matedata.enable:false is just only for sharding tables，my default datasource contains too many tables,this tables doesnt need sharding, but loadDefaultTables() took me an hour to boot my project.