LucienDon opened a new issue #9431:
URL: https://github.com/apache/shardingsphere/issues/9431
使用版本为4.1.1, oracle 一共有60张表,只进行了分表,我发现spring-boot 启动时, sharding-jdbc 会检索
oracle 元数据(metadata),与分表策略进行对比,这一过程非常慢(数据越多,启动越慢), 所以我想知道如何关闭检索metadata这一过程
我的spring-boot 配置如下
```
# sharding jdbc 配置
spring:
shardingsphere:
datasource:
names: ds0
ds0:
type: com.alibaba.druid.pool.DruidDataSource
url: jdbc:oracle:thin:@xxxx:1521/OSSDB
username: xxx
password: xxx
driver-class-name: oracle.jdbc.OracleDriver
sharding:
tables:
patient:
actual-data-nodes: ds0.PATIENT_$->{0..4}
table-strategy:
standard:
precise-algorithm-class-name:
djx.migratedata.config.strategy.PreciseAlgorithmForPatient
sharding-column: PK
exam:
actual-data-nodes: ds0.EXAM_$->{0..4}
table-strategy:
complex:
algorithm-class-name:
djx.migratedata.config.strategy.ComplexAlgorithmForExam
sharding-columns: HOSPITAL_ID,ACCESS_NUMBER
study:
actual-data-nodes: ds0.STUDY_$->{0..4}
table-strategy:
standard:
precise-algorithm-class-name:
djx.migratedata.config.strategy.PreciseAlgorithmForStudy
sharding-column: STUDY_UID
series:
actual-data-nodes: ds0.SERIES_$->{0..4}
table-strategy:
standard:
precise-algorithm-class-name:
djx.migratedata.config.strategy.PreciseAlgorithmForStudy
sharding-column: STUDY_UID
inst:
actual-data-nodes: ds0.INST_$->{0..9}
table-strategy:
standard:
precise-algorithm-class-name:
djx.migratedata.config.strategy.PreciseAlgorithmForStudy
sharding-column: STUDY_UID
files:
actual-data-nodes: ds0.FILES_$->{0..9}
table-strategy:
standard:
precise-algorithm-class-name:
djx.migratedata.config.strategy.PreciseAlgorithmForStudy
sharding-column: STUDY_UID
props:
check:
table:
metadata:
enabled: false
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]