I'm building a web app that hits up some APIs to get JSON dumps of data. I'm running across a problem. I can either grab all the data, dump it into a DB, then pull it from the DB as needed. OR I can just keep hitting the relevant API every time I need the data. (I have upwards of 7 different functions, each of which require a different set of input data which could be any combination of APIs, never more than three though).
I suppose it should be noted that the JSON dump changes daily. Not the keys, just the values (and total number of entries). So it's not like a one time dump into the DB, I'd have to refresh the DB every day or so.
So my question is, which is better? I'm guessing that constantly calling an API uses more bandwidth and thus takes longer, but I was also taught that one should avoid making tons of SQL requests if possible. Near as I can tell, I'd be making about the same number of calls/requests either way. So in terms of speed and bandwidth, which option would be better?