Will empty string take up more space? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Will empty string take up more space?

Message

From

22/10/2004 08:53:36

Km Kwun
Eastop Consultants Limited
Nt, Hong Kong

To

22/10/2004 07:31:29

Fabio Lunardon
Lunacom
Marostica, Italy

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Will empty string take up more space?

Miscellaneous

Thread ID:

00953619

Message ID:

00953696

Views:

14

Thanks for the information.

>On MS SQL NULLs are very optimized.
>Practically they do not occupy space.
>
>MS SQL allocation it is not linear,
>but with a simple table with 1 Text field
>show a 10/1 ratio for ''/NULL.
>
>Fabio

Click here to load this message in the networking platform