RE: One Big Data Base or Many Smaller Ones

2003-07-16 Thread Rudy Metzger
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

RE: One Big Data Base or Many Smaller Ones

2003-07-15 Thread Rob A. Brahier
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