Skip to Content
0

How to delete a query cache using CMOD

Apr 26, 2017 at 08:22 AM

91

avatar image

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

Ricardo Inácio 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

will it not affect performance?

0

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

0

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