V
V
Vladimir Kuts2017-11-23 12:57:07
MySQL
Vladimir Kuts, 2017-11-23 12:57:07

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 question

Ask a Question

731 491 924 answers to any question