hey guys

i apologise in advance if this is in the wrong forum

lets say i have a project where i need to have a database which stores user details and statistics relating to those users (what adverts they are displaying, how many clicks per adverts etc.)

would i be better off having one database with multiple tables (user table, advert table etc.) or should i split the details over multiple databases?

sorry if this question sounds dumb, i'm just not sure when you are better off using multiple databases or one database for a project.

thank you.

If you are having lesser number records, better off with one database. The mutiple database option only needed if it is required by a huge amount of data :)

It would be OK to use a single database with multiple tables...
Unless you are talking about the tables being a few GB in size...

Have a great day :)

regards
Amar