Deleting these inactive or users that never login before will definitely reduce your database tables size. This is because when you delete a user from Jooomla user manager / EasySocial user manager, EasySocial will also delete records that associated with the deleted users. E.g the stream items created by the user, the points history / badges history associated with the deleted users.

For your information, unpublish users will not reduce your table size as these records are still exists in the db tables. If you really want to reduce your db table size, you will need to delete these users.

Again, reducing db table size might or might not improve your website performance issues. If you think your website performance issues was caused by database queries, then I suggest you to enable the mysql slow logs and see if there are any slow queries being logged or not.

Some of users activated their accounts but never logged in (0000-00-00 00:00:00).

I've always wondered how these users with "Last Visit Date" of 0000-00-00 00:00:00 have activated their account?

If they haven't visited (?), how were these accounts made? Or, did they actually visit once but just didn't enable their account via email?

Any clarification would be appreciated.

Thanks. -- Rik

Some of users activated their accounts but never logged in (0000-00-00 00:00:00).

I've always wondered how these users with "Last Visit Date" of 0000-00-00 00:00:00 have activated their account?

If they haven't visited (?), how were these accounts made? Or, did they actually visit once but just didn't enable their account via email?

Any clarification would be appreciated.

Thanks. -- Rik

Hi Rik,

I've always wondered how these users with "Last Visit Date" of 0000-00-00 00:00:00 have activated their account?

If they haven't visited (?), how were these accounts made? Or, did they actually visit once but just didn't enable their account via email?

Regarding the above, most likely the user click on the activation link from their email after the registration. For your information, user do not need to login to activate their account and account activating process do not update the user's 'Last Visit Date'.

The other possibility is that you've configured the 'Registration Type' in your user profile type to 'Manual login' and if after user did not login to the site after they have registered, then this 'Last Visit Date' will not be updated as well.

Hope this help and have a nice day

"..some of users activated their accounts but never logged in (0000-00-00 00:00:00)"

probably spam reg bots

I would delete everyone of them.

I have not this problem anymore since I set up the site with Google captcha, a reg form with settings, spam checks, Enforce Honeypot Checks for Registrations Automatically Switch Key Daily and Admin Tools Pro settings...

Nice, thanks for sharing and it is good to know that the honeypot trap in EasySocial 4.0 is so effective