Re: ASP Design Question

Guido van Verseveld wrote:

> I am investigating the best way to set up our product and database up for an
> ASP model. This model should be able to support from 1 to 100 different
> users, which each should have their own set of data.
>
> I can think of 2 ways:
> 1. Create a separate schema for each user, but I can foresee a maintenance
> nightmare with that option;
> 2. Add an ID to each table, relating it to the logged in user, maybe
> partitioning the tables per this ID. The impact would be greater in the
> application, but I would only have to maintain one schema.
>
> I would like to hear from others who have tackled this issue of have other
> ideas.
>
> Thanks,
>
> Guido van Verseveld

Option 1. And I can't imagine why you think this is a maintenance nightmare. I've had databases with 100,000+ users and it was easily handled.

Daniel Morgan Received on Wed Jul 03 2002 - 17:04:24 CEST