homepage Welcome to WebmasterWorld Guest from 54.242.18.190
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
One Database for site and forum?
babil




msg:1580835
 7:49 am on Oct 18, 2005 (gmt 0)

Hello all,
I'm programing a database driven website and there will be a forum too. Should there be two databases, one for the site content and one for the forum? Or only one should do the work?
The traffic won't be enormous.
Any suggestions?

cheers babil

 

Frank_Rizzo




msg:1580836
 7:57 am on Oct 18, 2005 (gmt 0)

I presume you mean with something like MySQL and that you will have databases:

site (tables: articles, authors....)
forum (tables: messages, users, logs)

Best to keep them seperate as caching will be more efficient this way I believe. Also would be better for secuirty as you could set different permissions for each database incase a forum member managed to get hold of single password etc.

OK, in both cases table caching, or table permissions could do the same thing but it's easier to administer at the database level.

Another reason for having two seperate databases is that it would be easier to maintain backup scropts. You may want to backup the forum db every hour, and the site db every 24hrs. Again, this could be done with a single database but it's easier with two.

babil




msg:1580837
 8:11 am on Oct 18, 2005 (gmt 0)

hi,
thanks for the quick reply. It sounds very reasonable.
It is better to be on the safe side , even if it costs 1-2 euros more!
Thanks again
babils

Sarah Atkinson




msg:1580838
 3:19 pm on Oct 25, 2005 (gmt 0)

i have all of mine in one db but it is a very small db and we couln't see spending the extra $$. The site does not make us any $$ nor do the forums and while I have sujested adding advertisments. the board feels that doing so would afect our unbias image. I think I would perfer to have multiple db but given the situation the single db works just fine

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved