Search
Routing algorithm
Definition
- Refers to an algorithm used to locate physical tables (table shards) mapping a logical table based on routing fields. When you need to use a
logical table
to query data in the SQLConsole or change or export data, you can configure a routing algorithm to precisely locate target physical tables based on conditions. This helps improve the efficiency of your data operations.
- If you perform a data operation on a
logical table
without configuring a routing algorithm, the system will traverse all physical tables mapping the logical table. Consequently, the overall time consumed by the operation will be multiplied.
- A routing algorithm consists of routing fields and an algorithm.
Usage
- Query data of table shards.
- Change data of table shards.
- Export data of table shards.
Configuration
- Create or modify a routing algorithm
- Find the target
logical table
in the corresponding logical database
, and create or modify a routing algorithm for the logical table.
How helpful was this page?
Thank you! We've received your feedback.