what's the capacity of PivotCube?

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

what's the capacity of PivotCube?

Postby bashanwu » Wed Sep 12, 2007 3:49 am

what is max amounts of records which PivotCube can support? how many seconds it will use when access 30,000,000 records?

Thanks a lot!
bashanwu
User
 
Posts: 6
Joined: Sat Sep 08, 2007 3:53 pm

Postby AlexZencovich » Wed Sep 12, 2007 5:03 am

1
Max limit is RAM size. In theory it may use near 2GB reccords, but in Win32 you cannot load so much data in RAM.

2. If you have to load 30,000,000 it may produce cube with similar size and it may produce cube with 3000 cells only, it depend on data you have. You may check that with SQL command like

select dim1,dim2..dimN, sum(measure1) from facttable
group by dim1,dim2..dimN

more dimensions you have mean less chance for smaller cube.

The speed will determined in spped of SQL server you have used for upload 30,000,000 records in single query. For dbf table it may take hour just for TQuery.Open command.
You may check that as

Query.Open
cnt := 0;
while not Query.Eof do
begin
inc(i);
Query.Next;
end;
and check speed of query scrolling. Then approximate it in 3 times
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

re:what's the capacity of PivotCube

Postby bashanwu » Wed Sep 12, 2007 11:25 am

thank you for your help.
when read 30,000,000 records (use ActiveX) ,We will use DB server like DB2 or Oracle.In such situation:
1)is the cube file 's will be almost 300M? can it transfer by web?
2)when user access the cube,how many records return to user one time? in other way,is it support records scrolling?


thank you.
bashanwu
User
 
Posts: 6
Joined: Sat Sep 08, 2007 3:53 pm

Postby AlexZencovich » Wed Sep 12, 2007 4:19 pm

1. Yes, the cube file may be large, depending on number of measures and dimensions. It can be transferedd via Web, LAN etc. There is major MOLAP advantage - afte cube build it is independent meida.
2. Hmm..I have no idea what you mean as record scrolling. There is not SQL where you got records by parts. To navigate in mulidimensional space, user should have all records accessible at one time, withou scrolling because there are no idea where located records which will required at first step, next etc. All cube can be wrapped to single record (for example dimension Years and you have 1 year in cube) which will expanded to 10000 records etc.
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 5 guests

cron