Source: DBF file

Workstation: PC - Athlon 2.7 GHz, 512 MB RAM

Fields: 7, dimensions members: 10-15000. Facts:1

Distinct rows

Microcube generation (seconds)

Pivot (seconds)

Filtering (seconds)
50'000 0,84 0,02 0,03
100'000 1,51 0,08 0,08
500'000 8,50 0,93 0,90
1'000'000 21,73 2,05 2,42
3'500'000 109,09 5,48 3,55

Note: Because a usual database contains not unique rows, for example millions of sales transactions with repeated dates, product categories and items, the real data volume used for creating a microcube can be thousands times greater. So, Contour users can get a powerful BI just on a personal PC. Microcube stored on a web site or in a local network can be accessed by lots of users simultaneously. Contour products allow to create company's Business Intelligence solutions without expensive servers and with no administration.

 

Siemens test

Source: DBF file

Workstation: PC - PIII 600 MHz, 512 MB RAM

Not Unique rows

Cube loading time (seconds)

Data aggregation time (seconds)
5'000 <1 <1
80'000 7,0 19,0
160'000 14,0 38,0
640'000 59,0 153,0

Source: DBF file

Workstation: PC - P IV 2,0 GHz, 1'024 MB RAM

Not Unique rows

Cube loading time (seconds)

Data aggregation time (seconds)
5'000 <1 <1
80'000 2,0 6,0
160'000 5,0 12,0
640'000 20,0 51,0

1C:Rarus test

Database: MS SQL Server

Computer: Toshiba laptop Satellite Pro 4280 - Pentium 700 MHz, 256 MB RAM

Dimensions: 8. Facts: 2

Not Unique rows

Microcube generation (seconds)

Pivot (seconds)

Filtering (seconds)
4'250'000 360 2

An SQL table, resulted of a proxy server log processing, containing 4 million 250 thousand records was used as a data source. Field count is 10, table size is 370 Mb. OLAP report contains 8 dimensions (IP address, user login, URL, request kind, downloaded file extension, day, month, year) and 2 facts (transmission, reception). Total time spent is approximately 6 minutes. OLAP drill up, drill down and filter operation times are under 2 seconds, dimension moving is approximately 15 seconds.