FAQs About SQL-Development
Last Updated：2020-07-20
What size is proper for single-table data?
We recommend that the number of records in a single table should not exceed 2000w. If the number does exceed 2000W, recommend you to perform sharding action.
How to delete data by batch on single SQL?
Deletion sequence: primary key range > primary key "in" way > joint primary key. Data deletion range on single SQL: 800~1000.
What should be minded for single SQL insertion?
Recommend you to control the number of rows within 2,000. In batch action, you should execute the necessary "sleep". Also, recommend you to control concurrent tables with the "Auto Increment "key within 200.
What should be minded in grouping and sorting actions?
- As to limit result sets of "distinct", "order by", and "group by", you are advised to control the query statements within 10,000 rows;
- Recommend you to implement "Group by" and "Order by" actions with a result set exceeding 10,000 rows on the program side.