BookmarkSubscribeRSS Feed
mhamlett
Quartz | Level 8

my question concerns the amount of memory the results of a data query occupies in lasr as opposed  to the tables being loaded to lasr.

example

i have 2 tables in lasr (customer information,  sales detail data by day)

for example sake, lets say the customer is 500 meg in lasr and the sales detail is 500 meg in memory

 

each of the 2 tables stands alone in lasr and occupies in memory space in lasr ( 1 gig)

if i join these tables using the "Data Preparation Tool" to create a 3rd table of sales by customer, does the 3rd table occupy more than the physical memory space occupied by the individual tables? (at least another gig of memory) 

 

or is this type of join more "logical" whereas this is a virtual join and does not consume lasr memory in proportion to the physical tables.

 

thx

2 REPLIES 2
SASKiwi
PROC Star

I'm guessing you are asking if it is possible to store an SQL query VIEW in a LASR library. The view takes up virtually no memory but would dynamically join the two input tables when used. This reference confirms that views are possible:

 

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p0ci6glvfbc1kin1ipn3u...

 

I'm not sure what the impact on performance would be using a view - it would be slower than a table. Try it and let us know how you get on.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1305 views
  • 2 likes
  • 3 in conversation