Tim

How are you storing things internally?

eg does a BigInt actually take more space on disk than a SmallInt?

Does the format selected have any serious impact on processing speed?

Roy Lambert

Roy Lambert wrote:
> Tim
>
> How are you storing things internally?
>
> eg does a BigInt actually take more space on disk than a SmallInt?
>
> Does the format selected have any serious impact on processing speed?
>
> Roy Lambert
Tim
 An Aside, but related to disk space. If mass records are deleted froma
a table. Is that space avialabe to products like WindowWasher to wipe
the space occupied by thise records?
BTW the Sabres will win the cup. Sundays game was a thriller but the
Rangers won't get past Buffalo.

Allan B

Senators looked great last night.....

Walter

"Allan Brocklehurst" <brock@ns.sympatico.ca> wrote in message
news:2FA028B0-C237-4B6D-BA7E-566DD15EFA64@news.elevatesoft.com...
> Roy Lambert wrote:
>> Tim
>>
>> How are you storing things internally?
>>
>> eg does a BigInt actually take more space on disk than a SmallInt?
>>
>> Does the format selected have any serious impact on processing speed?
>>
>> Roy Lambert
> Tim
>  An Aside, but related to disk space. If mass records are deleted froma
> a table. Is that space avialabe to products like WindowWasher to wipe
> the space occupied by thise records?
> BTW the Sabres will win the cup. Sundays game was a thriller but the
> Rangers won't get past Buffalo.
>
> Allan B
>
>
>

Walter Matte wrote:
> Senators looked great last night.....
>
> Walter
>
> "Allan Brocklehurst" <brock@ns.sympatico.ca> wrote in message
> news:2FA028B0-C237-4B6D-BA7E-566DD15EFA64@news.elevatesoft.com...
>> Roy Lambert wrote:
>>> Tim
>>>
>>> How are you storing things internally?
>>>
>>> eg does a BigInt actually take more space on disk than a SmallInt?
>>>
>>> Does the format selected have any serious impact on processing speed?
>>>
>>> Roy Lambert
>> Tim
>>  An Aside, but related to disk space. If mass records are deleted froma
>> a table. Is that space avialabe to products like WindowWasher to wipe
>> the space occupied by thise records?
>> BTW the Sabres will win the cup. Sundays game was a thriller but the
>> Rangers won't get past Buffalo.
>>
>> Allan B
>>
>>
>>
>
>

Walter;
Yes they did. I Don't think Van is going to advance though. I'm a big
Habs fan so I have to view all of this with a bitter eye

Allan

Allan Brocklehurst wrote:
> Roy Lambert wrote:
>
>> Tim
>>
>> How are you storing things internally?
>>
>> eg does a BigInt actually take more space on disk than a SmallInt?
>>
>> Does the format selected have any serious impact on processing speed?
>>
>> Roy Lambert
>
> Tim
>  An Aside, but related to disk space. If mass records are deleted froma
> a table. Is that space avialabe to products like WindowWasher to wipe
> the space occupied by thise records?
> BTW the Sabres will win the cup. Sundays game was a thriller but the
> Rangers won't get past Buffalo.
>
> Allan B

Allan,
    Thanks for the sure thing. I'll be laying my bets down with my
bookie as soon as I get off the computer. (I don't have to split the
winnings with you, do I?)

Dave

Roy,

<< How are you storing things internally?  >>

For every column type, the space on disk is the same as you would expect,
except for:

DECIMAL = SizeOf(Currency) or SizeOf(Int64) under .NET
DATE or TIME = SizeOf(Integer)
TIMESTAMP = SizeOf(Int64)
YEAR-MONTH INTERVAL = SizeOf(Integer)
DAY-TIME INTERVAL = SizeOf(Int64)

CHAR values are stored without any leading length indicator, and no NULL
terminator
VARCHAR values are stored with an INTEGER length indicator, and no NULL
terminator

BYTE and VARBYTE values are stored in the same fashion

All BLOB/CLOB values are stored "as-is".

<< eg does a BigInt actually take more space on disk than a SmallInt? >>

Yes.

<< Does the format selected have any serious impact on processing speed? >>

What do you mean by "format" ?  Do you mean the display/edit format used in
your application ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Allan,

<< An Aside, but related to disk space. If mass records are deleted froma a
table. Is that space avialabe to products like WindowWasher to wipe the
space occupied by thise records? >>

No, it is only available for EDB to re-use as necessary.  If you OPTIMIZE
the table, then the space will be available for the OS to re-allocate for
other files.

<< BTW the Sabres will win the cup. Sundays game was a thriller but the
Rangers won't get past Buffalo. >>

Well, after last night's game they better pick it up in the work ethic
department or they won't get past this round.  I'm going to the game on
Friday night, and it should be a good one.

--
Tim Young
Elevate Software
www.elevatesoft.com

Walter,

<< Senators looked great last night..... >>

The Senators are playing like Buffalo played last year, and the Sabres are
playing like the Senators played last year.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

I suppose I was thinking is a smallint going to be faster in use than a bigint


Roy Lambert

Roy,

<< I suppose I was thinking is a smallint going to be faster in use than a
bigint >>

Actually, the fastest is to use the word size of the processor, i.e. 32-bit
Integer for 32-bit processors, and a 64-bit Int64 for 64-bit processors.

--
Tim Young
Elevate Software
www.elevatesoft.com