Database, should I use 2 or 1?
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.
Re: Database, should I use 2 or 1?
Reply #1 – 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
Re: Database, should I use 2 or 1?
Reply #2 – 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
Re: Database, should I use 2 or 1?
Reply #3 – 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