ElkArte Community

Project Support => Support => Topic started by: JesusGod-Pope666.Info on October 14, 2020, 04:55:22 am

Title: Database, should I use 2 or 1?
Post by: JesusGod-Pope666.Info on October 14, 2020, 04:55:22 am
I don't know much about databases, but I could make 2 or have 1 for both forums.
Is there any negative things having 2 forums in one database? Is it better to have them seperated?

I'm thinking of running SMF on one website and ElkArta on the other. Not sure if this is a good idea, but that was an idea so I don't have to choose one over the other. Although getting a good amount of censorship and muting on SMF at the moment, which of cause ruins the experience somewhat. In any case - I was thinking if there was anything bad using the same database.

I think there was something about there was only so and so many stickes one could do with the forum software, although not sure if that would be a database thing or something else that might make that wall.

It's easier to have in one database, but if there is any issues with it - I'll go for 2.
Title: Re: Database, should I use 2 or 1?
Post by: radu81 on October 14, 2020, 05:54:24 am
I'd go for 2 databese, but you con also use one database and be sure to use different prefixes for db tables
Title: Re: Database, should I use 2 or 1?
Post by: JesusGod-Pope666.Info on October 14, 2020, 07:39:38 am
Yea I know about the prefixes although I was wondering if there was any wall on something that might then be closer only using 1 compared to 2. Like there was something about only able to make 255 sticky posts in total - would that count for both forums in one database or would they both be able to do 255 or whatever the number was more in the line that I was worried about.

Thanks
Title: Re: Database, should I use 2 or 1?
Post by: radu81 on October 14, 2020, 11:31:05 am
If you use different table prefixes there is nothing to worry about

maybe you are referring to max 255 boards per forum, so you'd have max 255 for each forum installed
Title: Re: Database, should I use 2 or 1?
Post by: JesusGod-Pope666.Info on October 14, 2020, 11:49:37 am
Great to know - thanks. I have installed it in the same database with different prefexis and will hope for the best :)