Sunday, November 25, 2007

Published vs Popular

So until tonight, the date shown for stories was the "Loaded" (aka Published) date. This is when the second pass of the loader inserted the story into the DB.

This wasn't working well, as older stories would drop off after 12 hours (on the front page), even though they may have been made popular only a few hours ago.

So I went ahead and fixed that - if the only Loaded is available, that's the date displayed - otherwise it's when it was made popular (and I'm now setting that at the correct threshold). As I am now also selecting and order on that on everything but "All" (as those may not be popular yet), I had to go in and update the DB to correct old stories.

Looks to be working nice :)

No comments: