I need some advice on planning a database structure.
Is it a bad idea to break up your data into different databases? For example, if I am collecting:
username
password
firstname
lastname
address
etc
and then
last movie rented
favorite movie
…would there be any reason to break out the movie data from the user info data?
The reason I ask is that my hosting plan has a 100mb space limit. I’m sure i’m being too cautious about hitting the ceiling but I’d like to have a plan just in case.
If you had multiple databases with associated data, are you incurring a larger delay time to query the extra db? Just curious.
