Example: I have the following table (see picture below) that I created by fetching data directly from the API (see editor).
Problem: However, doing this means that the data will be calculated from scratch every time the user opens the page. Thus, the page loads very slowly.
Solution: Hence, I want to build a table in the database that is updated every set time, and that the user can easily access without the data being run every time he opens the page.
Solution technique: Use backend workflows that recreate the frontend table above in a database table, which is updated every set time.
Any inputs in solving this would be much appreciated.
thank you