Subject | Re: [ib-support] OT?: Fastest tablelayout |
---|---|
Author | Woody (TMW) |
Post date | 2003-03-04T17:04:37Z |
> Hi Martijn,Actually, I have to agree with Martijn here. Database design ultimately
>
> > What "fastest" - table design shouldn't be about speed, but about
> > consistency and normalized data structures.
>
> I must desagree with you! I think database design has a *lot* to do with
> speed (performance).
>
strives to be lossless and non-repetitive. While it may not always be
possible to achieve 4-th normal form, it should be the goal in the design
phase. Speed comes by designing queries to access the data. Since different
DB engines do things differently internally, one "design fits all" normally
doesn't happen.
Woody (TMW)
"Never trust a computer you can't throw out a window."
-Steve Wozniak