Deleting Tables

  • Resolved rayeason

    (@rayeason)


    3 years, 11 months ago

    Hello and good day.

    I have deleted users from an affiliate program, but wordpress still assigns non sequential ID’s to subsequent new affiliates.

    Will this help alleviate that problem by removing them?

Viewing 1 replies (of 1 total)
  • Plugin Author Jordy Meow

    (@tigroumeow)

    3 years, 11 months ago

    Hi @rayeason,

    This is the way MySQL works 🙂 I believe it can be changed, maybe by optimizing the tables (you can do this with the plugin), but at the end of the day, it’s really up to the DB engine. Auto-increment IDs are based on an internal counter, and its goal is to make sure the generated IDs are uniques, but that’s all. It will probably never fill the gaps of the removed IDs, except when you get to the maximum value of an ID 🙂

Viewing 1 replies (of 1 total)

The topic ‘Deleting Tables’ is closed to new replies.