1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

database tables

Discussion in 'XenForo Pre-Sales Questions' started by Bionic Rooster, Aug 9, 2013.

  1. Bionic Rooster

    Bionic Rooster Well-Known Member

    With a standard install how many tables are created? My provider has a limit per account.
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Your provider limits tables and not databases? There's a decent amount, let me see if I can find a number.

    There is roughly 150 (153 to be exact) in 1.2.
     
  3. Bionic Rooster

    Bionic Rooster Well-Known Member

    Odd but yes, unlimited databases but can not exceed 1000 tables total
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    153 in 1.2.0.
     
  5. Bionic Rooster

    Bionic Rooster Well-Known Member

    153 in a standard install, wow ok and then probably any add-ons could create their own I'm guessing?
     
  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    It depends on the add-on and their requirements, but yes, quite a few add-ons do include their own tables.
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Yes.

    XenForo with the Resource Manager is 160 for example.

    I doubt you will ever get to 1,000 tables though.
     
  8. Bionic Rooster

    Bionic Rooster Well-Known Member

    On 1 account I have 980 tables between 10 forum installs. And that's just 1 account. So with Xenforo I'm looking at 1600 tables with just RM and possibly more. I think it's time to remap accounts to accommodate as it looks like it will have to be cut in half per account.
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    Oh, it's per account and not per database.

    What an odd criteria.
     
  10. Jeremy

    Jeremy XenForo Moderator Staff Member

    Personally, I would be finding a new host. Limiting tables and not databases is a very odd requirement / restriction to have.
     
    Liam W likes this.
  11. Liam W

    Liam W Well-Known Member

    I was thinking the same thing...
     
  12. Bionic Rooster

    Bionic Rooster Well-Known Member

    Not if you have just 1 forum installed, even with Xenforo it would be hard (depending on the # of add-ons) to approach 1000 tables. But right now I'm averaging 10 forums per account each with its own sub domain. I've been dealing with this one host for over 15 years now and they have done right by me so I don't know if I want to change. I'll have a look see what others offer but the answer may be looking at dedicated or VPS plans. Crap more money LMAO
     
  13. Tracy Perry

    Tracy Perry Well-Known Member

    If you want your own dedicated and hardware RAID is not that important (and you will be regularly backing up your data yourself - which you should be doing anyway) then you may want to check out http://servercomplete.com/dedicated. I have 3 of them and have good luck with all 3. If you HAVE to have hardware RAID, you can purchase a RAID card for around $199 and they will install it for you.
     
    Last edited: Aug 10, 2013
  14. Bionic Rooster

    Bionic Rooster Well-Known Member

    Thanks for the link Tracy, I'll have a look.
     
  15. Tracy Perry

    Tracy Perry Well-Known Member

    I like them because when I got them the base server was $55 a month. The highest $ one I have right now is running around $110 (it has SSD's in it and 1GB uplink). Haven't had any downtime problems and what little support I've needed has been A+.
     

Share This Page