Answer the question
In order to leave comments, you need to log in
Working with OLAP mysql in Django?
Such a question - does anyone have experience with OLAP in django. Where can you read about it.
The essence of the problem is that there is a large read-only database.
It is necessary to make certain selections with data aggregation - let's say summing up a certain parameter from a selection of millions of records per year according to a certain criterion.
A typical query summarizing a selection from MySQL takes ten minutes, which is unacceptable. It is necessary to speed up the selection to fit in seconds - ten seconds ...
As I understand it, the task can be solved using OLAP, only how to approach it. And where can I read about this - about integrating this all into django.
Maybe there are other ways to solve this problem?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question