I'm loading a page with a lot of database processing(I guess) and it's taking about 3 minutes to load it.
I am trying to understand how to improve this. Unfortunatelly my knowledge of databases is still at a young stage.
A brief explanation of the query would be:
A table journal has an entry for eachday.
Each one of those entries have multiple manytomany fields from other table(analytic). (around 10 per journal entry)
This table analytic has around 100 columns.
I'm currently loading a full year of journal entries into a webpage, which is taking me about 3 minutes to load, which is not good obviously.
I'm trying to understand if there is a paramater in the pythonanywhere plan that I can improve to get a better performance, like web workers or something?
Or would postgres make a difference? Since Django recommends its use, and I'm currently using mysql.
Or anyother advice someone can give me?