I have this design question for experts out there ..
currently we have a single hosting database where we hosts many
domains(8-10) within single database.Each of there domains allows the users
to register themselves in to the site , so these users are inserted into a
single table say "users" which has a field to identify which domain the user
belongs to and there are other bunch of tables to support other
functionalitis. Now this "users" table is growing at a fast rate along with
other supporting tables.For performance/scalabilty and security reasons I am
debating the idea of creating different schema for each domain so that each
one of them have their owb "users" and other set of tables and one global
schema for common tables and sequences. Which gives advantages like better
performance ( if one domain have only 10000 users it will not suffer just
because others have 10000000) . Since oracle 8i provides invokers right we
can still have one piece of code.
Is it a good idea , considering no. of domains may go to 100s which will
lead to 100 schemas .Are there any other issues(particulerly admin) which I
am overlooking at ?
Pls Advice .
Received on Wed Jan 31 2001 - 22:25:59 CST
