same table in different databases with different data vs single table in singlle database

Actually i am designing a database in MySql, In that the structure is there is one root organization  and there are several child organization. So should I go for a single databse in which the group interrelated tables store the data identified by a unique id to differentiate each child organization.
Or should I maintain different databases for each child organization with the same table structure and same tables  in all of them, but data related to each of them.
Who is Participating?
Scott MadeiraConnect With a Mentor Commented:
Personally I would design the database as one set of tables holding all of the data. That way you can always aggregate data should the need ever arise.  For the actual data tables I would add an organizationID to indicate which organization the data pertains to.

If you do it the other way I can almost guarantee you that somebody will want to see aggregated data and you won't have an easy way to do that.
darien_softwareAuthor Commented:
please answer it
darien_softwareAuthor Commented:
Yes that is correct in multiple database environment it is difficult to get the data organization wise and year wise.but i am concern about performance.
darien_softwareAuthor Commented:
I am expecting a detail anatomy about the effect on the performance and all the detail ie when the tables from  multiple databases are loaded into memory.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.