Alright I have one particular table and it has over 10,000 entries in it.
The primary index is an auto-incrementing number, that coinsides with a Serial Number of a product.
When we delete an item from the database, we have not re-indexed because the serial numbers of the products in the field would not match up with those in the database.
Since we do not re-index, or repair/optimize etc, is this slowing down queries etc?
What would be adviced to do? Add in a new field as use that as the index, and then when an item is deleted, it will only reindex based on that field?