Hi Charla,
Generally if the tables will be related to each other then you want to keep
them in the same database. as an example, you would want to link quiz
scores to the individual students registered in your class. It is a little
easier to do table joins and such when there is only one database involved.
Besides which, most ISPS put a cap on the number of databases you are
allowed to create.
Hope that helps!
-Rob
-----Original Message-----
From: Charla Beaulieu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 12:33 PM
To: [EMAIL PROTECTED]
Subject: One Big Data Base or Many Smaller Ones
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/[EMAIL PROTECTED]
