[GitHub] [shardingsphere] zy1263188600 commented on issue #24648: Possible performance optimization of time slicing

["zy1263188600 (via GitHub)" <gi...@apache.org>]

zy1263188600 commented on issue #24648:
URL: https://github.com/apache/shardingsphere/issues/24648#issuecomment-1473362978

   ```properties
   #DataBase
   spring.shardingsphere.rules.sharding.default-database-strategy.complex.sharding-columns=id,start_time
   spring.shardingsphere.rules.sharding.default-database-strategy.complex.sharding-algorithm-name=database-inline
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.type=CLASS_BASED
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.strategy=complex
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.algorithmClassName=com.cdfortis.fbusihistoricaldata.config.algorithm.MyComplexShardingAlgorithm
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.datetime-pattern=yyyy-MM-dd HH:mm:ss
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.datetime-lower=2020-01-01 00:00:00
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.datetime-upper=2027-12-31 23:59:59
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.sharding-suffix-pattern=yyyy
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.datetime-interval-amount=1
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.datetime-interval-unit=YEARS
   ```
   ```properties
   #Table
   spring.shardingsphere.rules.sharding.tables.f_busi.actual-data-nodes=fbusi-$->{2020..2027}.f_busi_$->{(1..12).collect{t ->t.toString().padLeft(2,'0')}}
   spring.shardingsphere.rules.sharding.tables.f_busi.table-strategy.complex.sharding-columns=id,start_time
   spring.shardingsphere.rules.sharding.tables.f_busi.table-strategy.complex.sharding-algorithm-name=f-busi-inline
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.type=CLASS_BASED
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.strategy=complex
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.algorithmClassName=com.cdfortis.fbusihistoricaldata.config.algorithm.MyComplexShardingAlgorithm
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.datetime-pattern=yyyy-MM-dd HH:mm:ss
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.datetime-lower=2020-01-01 00:00:00
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.datetime-upper=2027-12-31 23:59:59
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.sharding-suffix-pattern=MM
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.datetime-interval-amount=1
   spring.shardingsphere.rules.sharding.sharding-algorithms.f-busi-inline.props.datetime-interval-unit=MONTHS
   ```
   Other configurations ignored @sandynz 


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