Article
· Mar 14, 2016 3m read

Reset your DeepSee cache in the DeepSee Shell

The DeepSee Shell Best Practices Series - Reset your DeepSee cache in the DeepSee Shell

This method is provided as a convenience for developers for use on development or test systems. You should not use this method on production systems as it will have immediate effect on the performance of end user operations.

  • Stops all DeepSee background agents
  • Clears any pending tasks
  • Clears the result cache for the current namespace.
  • If you use “reset 1”, then the cell cache for the current namespace is also cleared.  

>>reset 0

** Stops all DeepSee background agents, clears any pending tasks, and clears the result cache for the current namespace.

>>reset 1

** Same as above plus cell cache for the current namespace.

After you reset cache, the query you just run might take a bit longer because the result is not cached until you run it the first time after cache reset.

>>stats off

Stats are: off

>>SELECT {[Measures].[%COUNT],[Measures].[Allergy Count],[MEASURES].[MEDIAN TEST SCORE]} ON 0,NON EMPTY HEAD(NONEMPTYCROSSJOIN([AgeD].[H1].[Age Group].Members,[AgeD].[H1].[Age Bucket].Members),2000) ON 1 FROM [PATIENTS] %FILTER [GenD].[H1].[Gender].&[Female]

Patient Count Allergy Count Median Test Scor

1 0 to 29->0 to 9 69 45 73.50

2 0 to 29->10 to 19 74 47 75.50

3 0 to 29->20 to 29 80 56 68.00

4 30 to 59->30 to 3 82 43 77.00

5 30 to 59->40 to 4 75 49 75.00

6 30 to 59->50 to 5 58 43 68.00

7 60+->60 to 69 43 24 68.00

8 60+->70 to 79 24 16 70.50

9 60+->80+ 20 9 78.00

Elapsed time: .029869s

>>reset 1

Query cache reset

>>SELECT {[Measures].[%COUNT],[Measures].[Allergy Count],[MEASURES].[MEDIAN TEST SCORE]} ON 0,NON EMPTY HEAD(NONEMPTYCROSSJOIN([AgeD].[H1].[Age Group].Members,[AgeD].[H1].[Age Bucket].Members),2000) ON 1 FROM [PATIENTS] %FILTER [GenD].[H1].[Gender].&[Female]

Patient Count Allergy Count Median Test Scor

1 0 to 29->0 to 9 69 45 @Computing 0.00%

2 0 to 29->10 to 19 74 47 @Computing 0.00%

3 0 to 29->20 to 29 80 56 @Computing 0.00%

4 30 to 59->30 to 3 82 43 @Computing 0.00%

5 30 to 59->40 to 4 75 49 @Computing 0.00%

6 30 to 59->50 to 5 58 43 @Computing 0.00%

7 60+->60 to 69 43 24 @Computing 0.00%

8 60+->70 to 79 24 16 @Computing 0.00%

9 60+->80+ 20 9 @Computing 0.00%

Elapsed time: 3.768352s

Results pending...

Patient Count Allergy Count Median Test Scor

1 0 to 29->0 to 9 69 45 73.50

2 0 to 29->10 to 19 74 47 75.50

3 0 to 29->20 to 29 80 56 68.00

4 30 to 59->30 to 3 82 43 77.00

5 30 to 59->40 to 4 75 49 75.00

6 30 to 59->50 to 5 58 43 68.00

7 60+->60 to 69 43 24 68.00

8 60+->70 to 79 24 16 70.50

9 60+->80+ 20 9 78.00

 

The DeepSee Shell Best Practices Series

Run MDX queries in the DeepSee Shell

Get your MDX query performance stats from the DeepSee Shell

Reset your DeepSee cache in the DeepSee Shell

Execute an MDX query in the DeepSee Shell with/without results cache

Get your MDX query plan, MDX query trace and more from the DeepSee Shell

Example of using the MDX subquery flag in the DeepSee Shell

Debugging measures in the DeepSee Shell 

Discussion (0)0
Log in or sign up to continue