WordPress.org

Forums

duplication of tables in multisite database (6 posts)

  1. graybobby
    Member
    Posted 3 years ago #

    i am running a wordpress multisite for a university. I found out that the tables in the database get duplicated each time i create a new site for a lecturer.i am talking about 700 lecturers over here. what do i do to reduce the database size or any help to stop the database from crunching or working improperly

  2. That's how it works. One db can hold those 700 sites just fine.

  3. graybobby
    Member
    Posted 3 years ago #

    Thank you very much. But the issue is I am in Ghana, Africa where bandwidth is very expensive. Memory is another issue.More other sites will be created thus more tables.If most of my users are online at a time, qerry time will increase, more system resources will be taken and my system will be very slow thus bad performance. is there any other way or an alternative to a multisite, maybe a single site with multiple users or something. i want my users to still be the administrators of their sites. i really love my users and i'm hoping for a reply from you. thank you too for helping a whole lot of other people.

  4. If most of my users are online at a time, qerry time will increase, more system resources will be taken and my system will be very slow thus bad performance.

    That would be the same problem in any country if the web host is a small web host that has restricted things like RAM and CPU.

    It has nothing to do with bandwidth.

    If you want users to admin their own sites, then your choices are multisite or single installs.

    In most cases, most of your users will *not* be online all at the same time - unless you're running something like a classroom. In any case, a better web host will help.

    You can also install a plugin like hyperdb or shardb to split up the databases and spread the load - but you may still need better hosting for it.

    For the first couple hundred users you will not have an issue with this.

  5. graybobby
    Member
    Posted 3 years ago #

    Thank you but how do the hyperdb and the shardb work.
    (For the first couple hundred users you will not have an issue with this.)
    What about more than 700 users

  6. Thank you but how do the hyperdb and the shardb work.

    Please read the description on both those plugins.

    (For the first couple hundred users you will not have an issue with this.)
    What about more than 700 users

    That is the point you may need to think about scaling the db on the web server.

Topic Closed

This topic has been closed to new replies.

About this Topic