turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- LASR server memory consumption

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

a week ago

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

Accepted Solutions

Solution

Thursday

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to alexal

a week ago

@alexal wrote:

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).

---------------------------------------------------------------------------------------------

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

All Replies

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to babai88

a week ago

The answer is in your question.

---------------------------------------------------------------------------------------------

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to babai88

a week ago

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 !!

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 !!

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to babai88

a week ago

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.

---------------------------------------------------------------------------------------------

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to babai88

a week ago

Solution

Thursday

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to alexal

a week ago

@alexal wrote:

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

Maxims of Maximally Efficient SAS Programmers

How to convert datasets to data steps

How to post code

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to KurtBremser

Wednesday - last edited Wednesday

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.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to babai88

Wednesday

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.