Skip to Content
0

How to delete a query cache using CMOD

Apr 26, 2017 at 08:22 AM

92

avatar image
Former Member

Is it possible to delete a query cache using CMOD?
Because we are having an issue in RSRT, where the previous value in the selection parameter is being copied when you execute the report once again.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 26, 2017 at 11:25 AM
0

Hi;

In RSRT you can:

- Put your query

- go to properties

- Cache Mode -> 0 Cache is inactive.

Hope it helps;

Regards

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

will it not affect performance?

0
Former Member

if it will affect the performance of the report, do we have some remediation to avoid performance issue?

0
Former Member

Hi;

The cache will help the performance, but if you need to delete the cache this is a way.

You can test your query with and without cache: in RSRT run in debug and there are cache options.

Regards

0