Approximate number of users not correct even after optimize database

  • Resolved samhay

    (@samhay)


    1 year, 10 months ago

    Hello Ollie! Thank you for creating this fantastic plugin!

    My site have around 35,000 users but the users shown in the plugin is 10,001. I have followed your instruction to optimize the database. However there is no change in user number.

    Will this affect the performance?

    Also, there is no information in the setting page indicate where the user index is built or not. I would suggest a notice like Index WP MySQL For Speed would be clearer for users.

    Thank you again for the plugin!

Viewing 1 replies (of 1 total)
  • Plugin Author OllieJones

    (@olliejones)

    An inaccuracy in the displayed user count won’t affect any other part of the plugin’s operation. It’s just there to inform users. That number is only displayed, and not used anywhere else.

    I’ve tried to make the displayed count a bit more accurate.

    I really want to avoid SELECT COUNT(*) FROM wp_users, because that’s really slow for many users on the InnoDB storage engine.

    Thanks for the bug report.

    https://github.com/OllieJones/index-wp-users-for-speed/issues/8

Viewing 1 replies (of 1 total)
  • The topic ‘Approximate number of users not correct even after optimize database’ is closed to new replies.