SharkBait Posted September 16, 2005 Share Posted September 16, 2005 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? Link to comment https://forums.phpfreaks.com/topic/2515-optimizing-mysql-tables/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.