Re: Request: Large no. of small tables v/s small no. of large tables - which is better?

From: Rao <rao_at_interaccess.com>
Date: 1996/04/16
Message-ID: <rao.493.00219312_at_interaccess.com>#1/1

>In the current application we are desiging, the database need
>to support around 10,000 users. There are around 15 entities in
>the design. I can create 15 tables for each user resulting
>in 15,0000 tables, or just create 15 tables to be shared by
>all the users. I was wondering which one is better with respect
>to access performance.

It is crazy to 150,000 tables.

Go back to the drawing board, analyze why you need 15 tables for each user.

Rao Received on Tue Apr 16 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Piotr Machnik: "Designer 2000 and 101 entities in Database Wizard"
In reply to Shekhar Kirani: "Request: Large no. of small tables v/s small no. of large tables - which is better?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message