We have a system running Alf5.0, you can think that we have customized field in metadata that storing the person id (unique). When we search with the person id, if the no. of records is large (say 500 records), it needs more than few minutes to get the result. However, after this completed, the next search of the same person id returns the result in no time. But may be few hours / days later, the first search of it becomes slow again. And we guess this is the cache behavior (invalidated).
Can someone advise how to control the cache behavior such that we can cache person with many records and keep it not invalidated? Or any advice to make it user friendly on that? Thank you!