Slow WP-ADMIN due to users database

  • Hi,

    I have a wordpress website with 500,000 members. I am finding /wp-admin to be very slow and have been advised it’s because of the number of users in the database. Surely there are other sites out there with more users so wonder if there is a way to sort this issue?

    Thanks ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • Dion

    (@diondesigns)

    Even though WordPress is seldom used for that purpose today, one must never forget that it was designed as a blog application, and its internals are optimized for that purpose. The WordPress “meta” tables (_usermeta, _postmeta, etc) are constructed in a way that queries on those tables are slower and slower as more and more entries are added.

    Have you tried using an object cache that supports memcache? Otherwise, maybe you should consider migrating to an application that is better-suited to large numbers of members (and posts).

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    Really, the size of the DB isn’t the issue. We run this site on WordPress, and have 10 million+ user accounts. It’s a bit of a bigger setup, but not very different or special.

    Find the actual bottleneck. What specific thing is holding you back and making it slow. It’s not just “a really big table”, it’s some specific case or query on the database that slows the site down. Find that, then fix that.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Slow WP-ADMIN due to users database’ is closed to new replies.