Jump to content


Photo

Optimizing MySQL Tables


  • Please log in to reply
No replies to this topic

#1 SharkBait

SharkBait
  • Members
  • PipPipPip
  • Advanced Member
  • 845 posts
  • LocationMetro Vancouver, BC

Posted 16 September 2005 - 04:44 PM

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?





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users