Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Best practices on on implementing pivot tables on top of Oracle DB with large datasets

Christian Hillerkus asked on July 24, 2017


my team is currently looking at how to best implement slice & dice pivot tables for a .NET app that is built on top of an Oracle DB (12c). We are dealing with 3+ million transaction records but don’t yet have any data-warehouse and/or OLAP cube in place. Will the simple “optimized CSV” approach of Flexmonster scale with a dataset this large? In general, what are the best practices you guys would recommend for such a setup?
Thanks in advance,

1 answer

Dmytro Zvazhii Flexmonster July 24, 2017

Hello Christian,
Thank you for your questions. We have collected all our experience and shared it in the following article – It is a little bit outdated but the key ideas are still relevant. Speaking about your case, you need to choose between two options.

Please let us know if you have additional questions here.
Best regards,

Please login or Register to Submit Answer