Low performance with more of than 25 dimensions

Useful shares from PivotCube VCL - code example, algorithm solutions etc

Moderator: Alex Zencovich

Low performance with more of than 25 dimensions

Postby Patricia » Thu Jul 19, 2007 3:24 am

Hi Sir,

I've worked with more of than 25 dimensions, it's have had problems with performance. I've perceived that the time to build the PivotCube (using active:= false and active:= true) with 1600 records of the TClientDataSet is same with 7000 records. But I did test: I leave only 10 active dimensions and it better performance with same numbers of records.
what I can do possibly?
Please, some suggests?
I thought to use TPVDimToolBar with inactive dimensions, but I don't obtain sucess because this component list only active dimensions (enable = true).

I would like to ask excuses for my english
Thank's
Patrícia
Patricia
Guest
 
Posts: 1
Joined: Tue Jul 17, 2007 7:30 pm

Postby AlexZencovich » Thu Jul 19, 2007 5:18 am

How much is that 'low'? 100 milliseconds or less? By my tests with PivotCubeBenchmark it is

For 32 dimension and 1,700 records cube built take 2.5 seconds
For 16 dimension and 3,400 records - 1.6 seconds
For 10 dimension and 10,000 records - 1.6 seconds

but

For 16 dimension and 100,000 records cube built take only 7.7 seconds.
For 32 dimension and 100,000 records cube built take only 11,3 seconds.

(PivotCubeBenchmark is available with trial package, anybody can test on own PC)

You should expect - if you have increase number of dimensions/measures/records it mean more memory occupied by cube so it may use increase build speed for some little time.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 1 guest

cron