Invalidate DeepSee Result Cache for a Specific Cube

Question

Question

Jenna Poindexter · Oct 6, 2016

Hi-

I know that you can run the %Reset method within %DeepSee.Utils to reset all of the DeepSee tasks and reset the entire result cache.

Is there any way to invalidate the result cache for a single cube?

Discussion (8)1

Log in or sign up to continue

Jenna Poindexter · Oct 19, 2016

So this begs the question, how could one invalidate the result cache for the entire cube without running %KillCache as that purges the underlying globals and would interfere with actively running queries, correct?

0 0

score 1 · Answer 1 · 2016-10-06T09:32:34-04:00

You can call %KillCache method in a cubeclass. It does exactly that. For example:

write ##class(HoleFoods.Cube).%KillCache()

score 0 · Answer 2 · 2016-10-06T11:03:05-04:00

One concern with using this method is that it actually goes in and kills all of the cache for the cube by killing the globals containing the cache. What affect will this have if it is done while users are using the Analyzer for example?

score 0 · Answer 3 · 2016-10-06T13:00:01-04:00

Eduard Lebedyuk · Oct 6, 2016

Empty results or an error probably.

0 0

score 0 · Answer 4 · 2016-10-19T11:45:45-04:00

As mentioned already, running ##class(HoleFoods.Cube).%KillCache() would actually go in and purge the internal globals associated with the result cache for that particular cube. Not really the best thing to do on a production system.

A safer way to invalidate cache for a given cube would be to run %ProcessFact for an individual record within the source table for the cube.

For example

&sql(select top 1 id into :id from <sourcetable>)

do ##class(%DeepSee.Utils).%ProcessFact(<cubename>, id)

replacing <sourcetable> with the source table for your cube and <cubename> with the name of the cube.

This has the effect of causing the result cache for the cube to be invalidated without completely purging the internal globals that store the cache. This is much safer to run during production times than the %KillCache() method.

score 0 · Answer 5 · 2016-10-19T12:08:00-04:00

It would only invalidate one chunk (most probably first, but ultimately it depends on id) of cube data, not all of them.

score 0 · Answer 6 · 2016-10-19T12:35:23-04:00

So if we were to use the APIs to update the dimension table directly for example, this would not be adequate to insure that future queries showed the proper data?

score 0 · Answer 7 · 2016-10-19T12:38:02-04:00

It would, because cache for that chunk would be invalidated, and cache for other chunks would still be valid. But OP wants to invalidate cache for a whole cube, and for that inserting one fact is not enough.