I have a table that has a very high turnover of information, that is, many records come in and many come out as well. With this the ID (auto-increment) is much higher than the data value in the table.
For example, the table has 530 records and the (auto-increment) ID is at 1250, and those numbers tend to increase relatively quickly.
I wonder if this can cause some slowness or it can be bad in some way for my database and my application. If it causes any problems, what can I do to improve this?
Note: I do not know if it changes into something, but the IDs of this table are foreign keys in other tables.