I ran some benchmarks for the OLAP components in Flex. The OLAP components allow you to perform you’re OLAP operations client side out of the box. You *can* utilize the SDK interfaces and move your processing to the backend, should you have too much data for the browser.
That said, the benchmarks below should help define the line for “too much data.”
Grade:Number (Our measure)
Records / Processing Time (s)
1,000 / 3 sec
5,000 / 12 sec
10,000 / 22 sec
15,000 / 33 sec
20,000 / 43 sec
The processing times listed above are for the *client* side processing time. The data was loaded from the server before starting the benchmark.
I ran the benchmarks at various rollup depths (multiple hierarchies) which the components actually handled very well, the processing time was not significantly affected.
Extending the dataset to 125K+ records caused errors with the script timeouts occurring.
For datasets above 5-10K records, I’d suggest moving the processing to the server and passing the results to the UI. (assuming you’re looking to leverage the OLAP components as provided)