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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
thanks.
thanks.
ASKER
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.
ASKER