I have a process where there could potentially be frequent rollbacks to a table keyed by an auto_increment column. Since this causes gaps in the auto_increment value, I’m wondering if there are, or could be, performance implications. Will these gaps (vs if there were no gaps in the auto_increment column value) slow down queries as the table grows? I’ve run some small scale tests and have not seen any differences in query performance…yet.
If I understand it correctly, there will be no performance degradation.