alt Hacker NewsJust professionally, I'm curious whether they derive has_not_been_viewed_much by some nightly cron process, by an insert trigger on a `user_image_viewed` table, or by some monstrous full table join that HN is currently obliterating.
Just professionally, I'm curious whether they derive has_not_been_viewed_much by some nightly cron process, by an insert trigger on a `user_image_viewed` table, or by some monstrous full table join that HN is currently obliterating.
There's a scheduled task that runs every month to pull the view data from Google Analytics:
https://github.com/art-institute-of-chicago/data-aggregator/...
https://github.com/art-institute-of-chicago/data-aggregator/...
The site hasn't been hugged to death yet,