LASR server memory consumption

[babai88]

How much byte of memory does LASR server take to store a length 1 character data and lenght 8 numeric data ?  

[Kurt_Bremser]

The answer is in your question.

[babai88]

Thanks Mr. Bremser,

I tried to estimate total table space considering each character takes 2 bytes and length 8 numeric takes 8 bytes. This gives me a fair estimate but not a exact or almost exact memory consumption value !!

[Kurt_Bremser]

There will always be an overhead for metadata, and artifacts of the page-wise organisation of datasets. But a 1-character field needs one byte, and the larger the dataset (in terms of observations), the smaller the overhead.

[alexal]

@babai88,

Each column in the LASR server is padded to an 8 byte boundary. If the character variable you are adding is not a multiple of 8 bytes, the variable will be padded to an 8-byte boundary.

[Kurt_Bremser · Accepted solution]

---

@alexal wrote:

@babai88,

Each column in the LASR server is padded to an 8 byte boundary. If the character variable you are adding is not a multiple of 8 bytes, the variable will be padded to an 8-byte boundary.

---

Didn't know that. Now that can blow up a dataset quite nicely (if it contains lots of y/n type variables).

[babai88]

Is there anything like 8 byte padding in case of numeric columns ?

A numeric column of length 8 takes up 8 bytes of memory? Please correct me if I am wrong.

[SASKiwi]

Correct. Numeric columns use 8 bytes of storage by default so no padding is done for these. If the LASR load table contains shortened numerical columns I presume padded would be done for these too.