java - Whether users from different regions are divided into tables and groups in the database

Question

For example, for takeout products, in order to facilitate the allocation of user orders to deliverymen, users in the same area will be grouped in the database. If they are grouped, there will be many areas and many groups.

Answer 1

MySQL partitioning is based on latitude. According to your example, it is generally oriented to two latitudes: users and merchants. Division by region is of little significance.
Amway Yibo姿势
Dianping order system sub-database and sub-table practice