I'm building a WordPress plugin for a client and I want to know the best way for managing the data pulled from the API. For example, if I were to load a TV show should I then store the resulting data in a local database table for quicker look up? Or for speed and performance is it best to query the API each time?
Same goes for looking up seasons and episodes for a TV show. I could query the API for these and store them locally when I first load the TV show. Or I could just store the TV show id and perform all these queries on page load (go get the TV show name, all the seasons and episodes).
I hope this make sense. Thanks in advance.
Can't find a movie or TV show? Login to create it.
Want to rate or add this item to a list?
Not a member?