what's the capacity of PivotCube?

[bashanwu]

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!

[AlexZencovich]

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

[bashanwu]

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.

[AlexZencovich]

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.