I'm creating a plugin which counts social scores on various sites. It uses the various API's available on the web to determine a "count" of shares or likes across facebook, twitter, delicious, linkedin, stumbleupon, digg etc.
My problem lies in the speed of the response for the networks. They can be slow, so I'm looking for architecture / design advice. I was thinking of creating a table which holds POST_ID and a collection of scores which is updated often via WP-CRON.. and updates when a user clicks the share button as well to keep it in synch. Sound like a valid idea? Or any other ideas?
If you are still confused, take a look at the new share button on the BBC. I want to bring this to Wordpress, minus the speed overhead.