cancel
Showing results for 
Search instead for 
Did you mean: 

Cache spec. in Lookup function

Former Member
0 Kudos


Hello,

What is difference between 'PRE LOAD CACHE" and DEMAND LOAD CACHE" in lookup function .

Regard

Ajay

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member187605
Active Contributor
0 Kudos

PRE_LOAD_CACHE will load the full lookup table in memory.

DEMAND_LOAD_CACHE will only load those parts of the table you're actually referring, too. Useful for tables to big to cache completely in memory, for history lookup tables (where you only referring to most recent data)...

Former Member
0 Kudos

Hi Ajay,

Pre Load cache :

This option will load all the data (return column list,compare column & order by column list) into memory(cache) after applying constant filters if any and before executing lookup function.

Demand load cache :

This option will load all the data (return column list,compare column & order by column list) into memory(cache) as function identify them.

Now, we can use pre load cache option when lookup table has less number of rows or you expect to access hight percentage of rows from lookup table.

while you can use demand load cache when number of rows in lookup table is large and also you expect to access low percentage of rows from lookup table.

also, when you are using single table in multiple lookups & compare conditions are highly selective so resulting in a small subset of data then you can go for demand load cache.

Thanks,

SB