How to create pre-computed tables in order to speed up the query speed
-1
votes
1
answer
607
views
One of the issues that I am encountering presently is that we have certain very large tables (>10 Million rows).When we reference these large tables or create joins, the speed of query is extremely slow.
One of the hypothesis for solving the issue is to create pre-computed tables, where the computation for the use cases will be done already and instead of referencing the raw data, we will query the pre-computed table instead
Are there any resources in order to implement this ? Do we only use mySQL or can we also use Pandas or other such modules in order to accomplish the same
Which is the optimal way?
Asked by databasequestion
(1 rep)
Sep 7, 2022, 01:49 PM
Last activity: Sep 7, 2022, 05:30 PM
Last activity: Sep 7, 2022, 05:30 PM