young138120 opened a new issue, #25251:
URL: https://github.com/apache/shardingsphere/issues/25251
version: 5.3.2
backgroud:
i have big many tables with more than 100 million rows in database_a，i want
split those tables by year ，and move it to anther databases like
database_2020,databse_2021,database_2022。
i use shardingsphere proxy server to sharding select , i don't execute any
insert or update dml
now ,i set database_a datasource to single table datasource , you know many
of other table in databse_a exclude big table.
i run join sql with singe table and sharding table , proxy server will scan
all of sharding table like this:
i get some advice from sphereEx , i need to change single table to
broadcast table ，because of single table can not join with sharding table。
so how can i design 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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
