Skip to Content
author's profile photo Former Member
Former Member

Cache spec. in Lookup function


Hello,

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

Regard

Ajay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2015 at 07:37 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 27, 2015 at 08:57 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.