Re: Pizza Example
Date: Tue, 6 Apr 2004 10:02:49 -0400
> Or, at the design stage, you simply accept the fact that length is
> variable, and expect your database to be clever enough to cope :-)
Very good point. In fact a good DBMS will apply compression to save space, with no information loss. And, in general, the time saved by saving space will be more than the time expended in compression/decompression. And, when odd cases occur, the DBA can tell the DBMS what to do.
However, there are some situations where variable length data is unacceptable design, and not for reasons that can be hidden inside the DBMS. Other writers have given several examples in this thread. Received on Tue Apr 06 2004 - 16:02:49 CEST