One Big Data Base or Many Smaller Ones

[Charla Beaulieu]

Hello,

I am creating an on-line course and would like to know if it will make a
difference in the way I set up my database(s).

Option 1 : Create one large Database for the course

Here I would prefix the tables with their functions, ie. reg_ quizzes_
forum_ etc.

Option 2 : Create a smaller Database for each function

Here I would create a registration database, a quizzes database a forum
database etc.

I do not have my own server, so I would have to get my ISP to create
each database, which might be a hassle for them.

I want to know which method would be best.

Thank you

Charla

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw