Caching data

[Floris]

Ok, so I have a script now that I can call as a standalone (blah.php?show=x) which lets me query a remote site tvrage.com for show X. Yay.

This info is going to be shown in the forum that has tv show notes, so the info like next episode, and air date is listed. Of course, we dont' want to trigger this each time a user browses to the page. So it has to get it once, store it in a table:forum field with a timestamp and then check if it has been say .. 12 or 24 hours, before it does a remote query again (and if the time hasn't passed yet, use the existing data).

Now, how do I best approach this? We have about 50 forums, one for each tv show, so we're trying to keep the query count a bit low. I am curious what your thoughts are. Oh, we're already using a plugin to get data from the forum into the tvshownote box. You can check it as example here http://wetalk.tv/heroes/

Thanks for your help.

[Dismounted]

Well, the optimum solution (in my opinion) would be to run a *nix cron every 12/24 hours to query for the info, then store it in the local database. All you would have to do then would be to query the local database for the info.

[Floris]

Thanks for the info.

[Princeton]

I'm assuming you want to use this "data" as the forum description or in addition to forum description ...

if so, you can append parsed to forum description and save as description OR you can create a new forum field and save the parsed info there

if you opt to create a new forum field make sure you are able to edit the field via the Forum Manager (under Description) - this will allow you to edit the data if needed