Which is the best structure ...

[Ruslan Zasukhin]

On 5/8/04 4:33 PM, "Thierry Nauze" <huancaya at wanadoo.fr> wrote:

> Which is the best structure, knowing that less than 25 % of fields
> 'texte' will not be empty.
> 
> First case:
> TABLE   sources
> id        UMedium
> idX        UMedium
> idY           UMedium
> texte     VarChar(1016,'French')
> 
> 
> Second case:
> TABLE   sources
> id        UMedium
> idX        UMedium
> idY           UMedium
> IDTexte     UMEDIUM
> 
> TABLE  textes
> idTexte    UMedium
> texte     VarChar(1016,'French')

In Valentina there is no need move out big fields into second table.

So you can use the first case.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------