Re: Database Design

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Tue, 15 Jul 2003 20:16:09 +1000
Message-ID: <3f13d5dc$0$31920$afc38c87@news.optusnet.com.au>

"Rushikesh" <rbaiwar_at_sify.com> wrote in message news:2b29906c.0307142123.1d020801_at_posting.google.com...
> I am designing a WEB BASED Accounting Software with ASP and SQL
> Server. For this I need some help for the Database design. My design
> is as follows.
>

You may need a lot more than just these tables.

> and thus the record fetching time for a particular user increases as
> many times as there are users in the Database.

Oh no, it doesn't!

> will access the same tables, and for even a single user the complete
> table will be loaded in memory.

It is ridiculous if you write your code to do that.

>
> WHICH DESIGN SHOULD BE USED AS FAR AS SPEED OF SERVER IS CONCERNED?
> PLEASE HELP WITH CONVINCING REASONS.
Second.
Read a few texts about database design and normalization.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue Jul 15 2003 - 05:16:09 CDT