database tables

[Bionic Rooster]

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

 

[Jeremy]

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.

 

[Bionic Rooster]

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

 

[Paul B]

153 in 1.2.0.

 

[Bionic Rooster]

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

 

[Jeremy]

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

 

[Paul B]

Yes.

XenForo with the Resource Manager is 160 for example.

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

 

[Bionic Rooster]

Yes.

XenForo with the Resource Manager is 160 for example.

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

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.

 

[Paul B]

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

What an odd criteria.

 

[Jeremy]

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

 

[Liam W]

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

I was thinking the same thing...

 

[Bionic Rooster]

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

 

[TPerry]

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

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.

 

[Bionic Rooster]

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

 

[TPerry]

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

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+.