Re: lookup cache clarification

2020-12-09 Thread Marco Villalobos
But when I monitor my database, it only shows one query. It does not show a query every 20 seconds. It seems that since the cache is 10 times larger that the records are kept even though they expired. > On Dec 9, 2020, at 4:05 AM, Danny Chan wrote: > > Yes, you understand it correctly. > > M

Re: lookup cache clarification

2020-12-09 Thread Danny Chan
Yes, you understand it correctly. Marco Villalobos 于2020年12月9日周三 上午4:23写道: > I set up the following lookup cache values: > > 'lookup.cache.max-rows' = '20' > 'lookup.cache.ttl' = '1min' > > for a jdbc connector. > > This table currently only has about 2 records in it. However, > since I

lookup cache clarification

2020-12-08 Thread Marco Villalobos
I set up the following lookup cache values: 'lookup.cache.max-rows' = '20' 'lookup.cache.ttl' = '1min' for a jdbc connector. This table currently only has about 2 records in it. However, since I set the TTL to 1 minute, I expected the job to query that table every minute. The documentat