3 ms·
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,
by noduerme 4mo ago
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.
- zach_garwood 4mo agoThere'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/blob/1eeb87ce21f51f27034eafabbd1eeae7a70aa2c2/app/Console/Kernel.php#L133-L134 https://github.com/art-institute-of-chicago/data-aggregator/... https://github.com/art-institute-of-chicago/data-aggregator/blob/1eeb87ce21f51f27034eafabbd1eeae7a70aa2c2/app/Console/Commands/Import/ImportAnalytics.php https://github.com/art-institute-of-chicago/data-aggregator/... The site hasn't been hugged to death yet,