Page 1 of 1
Informational Service related question
Posted: Fri Apr 28, 2017 9:29 am
by anajitKS
I have created an Informational service which has got 2 lookup stages using normal lookup (Not Sparse) involved in it. My question is, is it going to load lookup data in the memory with every request the service receives? or is it going to hold on to the old data that it loaded at the time of the first request?
Posted: Sat Apr 29, 2017 5:24 pm
by ray.wurlod
Is your job "always running" or "start on demand"? Answering that will basically answer your question.
Posted: Mon May 01, 2017 8:06 am
by qt_ky
Normal lookups are loaded into memory only once when the job starts. If the reference data may change regularly then you could script the service to disable/enable on a schedule in order to force it to restart the job. Of course you would have a small outage during each restart.
Posted: Mon May 01, 2017 9:49 am
by eostic
...or use sparse lookups instead. They are preferred for realtime (always on) Jobs for exactly this reason.
Ernie
Posted: Mon May 01, 2017 10:46 am
by chulett
... unless it is static reference data.
Posted: Mon May 01, 2017 1:41 pm
by qt_ky
Indeed... unless the database on the other end of your sparse lookup has a lot of outages.