Potential Database issue

[freesoftwarewiz]

This is the second time reporting this issue. The first was on the wordpress.org site.

When a user is deleted from the SimpleMembership users DB, the user ID is never re-used.
The next user added, is given a new ID.
It leaves a “hole” – a record flagged as deleted – in the DB.

UNLESS the user is physically deleted from the DB you will have performance issues.
If you have thousands of users and lots of turnover (users joining, users deleting their accounts, etc.) accounts marked as deleted but NOT deleted will severely affect DB performance, which affects the site.

The other issue is User ID Mismatch.
In simplemembership, if you delete user ID 1 (call him Bob), user ID 2 (call him Joe) STAYS as User ID 2.
BUT WordPress re-assignes User 2 (Joe) and gives him User Id 1
So now Joe is Subscriber ID 1 in WordPress, and ID 2 in simplemembership

That, can be confusing as hell.

Joe C.
Chief Engineer, Dead Parrot Software

[nur]

THIS IS NOT AN ISSUE. we have intentionally kept simple membership user id and wordpress user id separate. if this sounds confusing to you then you are using this plugin for wrong purpose. you should look for alternatives.

Thanks,

[Author]

Posts