Hi guys
For some reaosn auto-increment of product id has gopt out of whack and there is a big gap in the number sequence is there a way to fix this?
Chris
this is normal, and will happen as records get deleted and imported, with unique-id's a number does not normally get reused
Will this slow down the database over time?
No; it's not a problem at all. This is normal practice for almost all database applications.
it is purly a way to ensure that every record get a unique id, as some application use the uniquie ID to tie things together
the only way to ensure it remains unique is not to allow numbers to be reused
Hi Chris,
A PHP script can't have any control over the auto-increment value within a MySQL database table. It will always increment for as long as there are records in the table; even if a large block is deleted those numbers will never be "resused".