Forum Academy Marketplace Showcase Pricing Features

API and database: Create database table with API data

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