Forum Moderators: phranque

Message Too Old, No Replies

How many applications on a SQL database?

         

zulufox

1:49 am on Mar 4, 2004 (gmt 0)

10+ Year Member



My site is run on a php/SQL database with about 200 articles.

Now I'm adding a phpbb forum and product database.

Should I put each one of these applications on their own database, or should I just store all the data on one database.

txbakers

4:36 am on Mar 4, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I would create separate databases for separate websites. That way you can create different passwords for each and limit exposure.

You only need one mySQL server installed.

vrtlw

9:46 am on Mar 4, 2004 (gmt 0)

10+ Year Member



I would create seperate databases for each application on a website, one SQL server, and in your case two databases. Makes it safer should table names conflict between apps.