数据库删除数据导致id不连续,有什么影响么?性能或者其他方面的影响。。
光阴似箭催人老,日月如移越少年。
No problem, you can modify your table structure to make it continuous
No impact, just add indexes to frequently queried fields
ID is just a unique identifier, it doesn’t matter. . And try not to use ID as the primary business key during the development process
It has no impact. In some designs, the ID is a string generated using UUID(), which is not continuous in the first place
UUID()
No problem, you can modify your table structure to make it continuous
No impact, just add indexes to frequently queried fields
ID is just a unique identifier, it doesn’t matter. . And try not to use ID as the primary business key during the development process
It has no impact. In some designs, the ID is a string generated using
UUID()
, which is not continuous in the first place