CacheLookup Property in Ax 2012 R3

Finance and Operations/AX Developer Forum
1

Hi,

Can you please any one let me know What is the main purpose of CacheLookup property in AX 2012 R3.

Read couple of articles in MSDN & other blogs, but it is not clear for me.

Please give some best examples.

Thanks in advance

2

Record cache is, obviously, about caching records. They’re kept closer to where they’re (may be) needed, therefore AX doesn’t have to connect to database every time.

Make sure you’ve read Single-record Caching on MSDN - CacheLookup is explained there in great details and repeating it here would be just a waste of time.

If something is still unclear to you, please explain what exactly it is.

3

Thank you Martin,

Before post my Question, I read that Article on MSDN,.

but my question is when we select CacheLookup Property as a Found, FoundAndEmpty and NotInTTS.

Thank you

4

You choose the type of caching (explained in the link above) you want, depending on how the data is used. Read how it works and then apply it according to your needs.

For example, if you want to cache information about non-existing records, you’ll use FoundAndEmpty, because Found wouldn’t cache it.

5

Thank you for information,

I will try Practically, may be i will get full Idea on this.