Nov-16-2016, 09:26 PM
Hi @nilamo,
Thank you for reply, I appreciate it.
Optimizing queries, raw SQL and caching is a way to go and I would like to explore more options just in case.
You mentioned something interesting, OLAP cube. I would like to understand it little better. Let's say I want to do some analysis on the data that is stored in SQL. It is not online reports in terms of minutes or hours. Last day is the maximum we need. Would you use any OLAP servers in this case and do you have any recommendations?
Thank you for reply, I appreciate it.
Optimizing queries, raw SQL and caching is a way to go and I would like to explore more options just in case.
You mentioned something interesting, OLAP cube. I would like to understand it little better. Let's say I want to do some analysis on the data that is stored in SQL. It is not online reports in terms of minutes or hours. Last day is the maximum we need. Would you use any OLAP servers in this case and do you have any recommendations?