OSBI/saiku — Issue #83: Slow performance of rendering dimension levels
Author: all4miller
Created: 2011-11-07 09:03:28+00:00
State: open

Hi There

I noticed slow performance of formatting/rendering of dimension levels with lots of members.

Test Scenario:

1. Using the FoodMart Sales cube as per the demo
2. I dragged Product Name on rows, and Profiit on columns
3. I turned on debug logging
4. I see this in the logs. Notice the "Format:" time is almost 10 seconds vs the execution time which is much lower.

first execution cold cache

10:52:37,510 DEBUG [QueryResource] TRACK	/query/690E683B-3599-FB9C-8F19-893895E30CB2/resultcheat	GET
10:52:48,883 INFO [OlapQueryService] Size: 2/1560	Execute:	2069ms	Format:	9296ms	Total: 11365ms

second execution warm cache (Format time is the same)

10:52:57,666 DEBUG [QueryResource] TRACK	/query/690E683B-3599-FB9C-8F19-893895E30CB2/resultcheat	GET
10:53:07,393 INFO [OlapQueryService] Size: 2/1560	Execute:	533ms	Format:	9194ms	Total: 9727ms

To put this is perspective running the same mdx in Schema Workbench takes roughly 2 seconds including dumping results to display for cold cache, and <500ms for warm cache.

This is just an example. I have a real requirement running off of InfoBright database that is taking 70 seconds to "Format" results vs <=500ms to execute and create results.

Cheers
Angus