For a Roto MLB league, I was wondering if the league_update_timestamp for each league gets updated when anything changes in the league (such as a transaction or message board post) or if it is only updated when the standings are updated every night. I'm using the following query in a roto baseball league.
The follow up question is if the above answer applies to other types of leagues. In another post you mentioned that H2H points leagues get updated with live data. In that case I'd assume the league_update_timestamp is close to actual time whereas for roto leagues it appears to be some time in the morning.
In all cases, the league_update_timestamp should correspond to when we do our overnight updates for your league, which effectively is just when the league standings are updated ('cause we try to take care of a lot of the other stats in realtime, at least as far as display goes). It'll happen once per day (unless things go horribly wrong on our side :D), usually somewhere around midnight to 2am. The distinction on our end is that for most of the realtime stuff that you see on the site, we're doing calculations on the fly; our overnight update is when we make sure we have final stats and actually store all the new information for the day.