Hi I have been doing some tests with the api. Thinking of creating a fixtures/results application.
I am wondering what is the best starting point for my application. I will be working in PHP.
As there is a limit to how many calls you can make to the api in a day it is neccessary to cache the data from the api in some way. I have thought of 2 potential aproaches to this:
1) Store the OpenFooty api data in a mysql database and use a cron job to update the information at set times.
2) Store copies of the OpenFooty xml files on my server and use cron job to overwrite them at set times.
Which do you think will give the best performance? Bearing in mind that most data, such as leagues/teams won't need to be refreshed too frequently, but other data such as results would need to be refreshed more frequently