I have a table to store merchant offers that updates via a script - eventually every night.
The first thing the script does is delete all the existing offers from that supplier then pull in the current offers.
Each offer has an id which is auto incremented.
The total number of rows in the table is unlikely to get above a few thousand, but the id is already up to tens of thousands and will rise quickly to millions - will this cause any problems, or should i periodically drop and recreate the table, and zero the id column?
Bookmarks