Really depends on what exactly you want to achieve. But as I read the mail below, create a lot of smaller ones. If the ISP however charges you for each DB it is also easy to only create one huge DB, just do not make the table names too long. Developers are lazy in typing... :)
/rudy -----Original Message----- From: Charla Beaulieu [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 18:33 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
