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,
Thank you for your questions. We have collected all our experience and shared it in the following article – http://www.flexmonster.com/blog/blog-perform-faster/. 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.