I would give each customer their own schema regardless of 50 or 200.
Jim
<nm1638_at_my-deja.com> wrote in message news:8tdc9u$oho$1_at_nnrp1.deja.com...
> Anyone have experience setting up a Oracle server
> for Shared-Web-Hosting in an ISP ?
>
> Is there any traps and pitfalls we can avoid.
> Should we set it up mutliple databases (one
> database for each customers) ? Or should we set
> it up as one database with multiple schemas (each
> customer have one schema) ?
>
> My company is planning to offer Share-Web-Hosting
> services to our customers. Our customer can put
> their web site on our web servers and their web
> site can read and write to an Oracle server as
> well.
>
> The number of customer we have probably affect
> the answer to the above questions.
> If we are haveing 50 customers what is the best
> approach.
> Or if we have 200 customers, what is the best
> approach.
>
> Thanks,
> Nelson Mak
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Oct 28 2000 - 00:03:02 CDT
