So how are you solving the example in the article where they join on timestamps? Read both tables from the DB into the application?
I read raw data (UTC timestamps) from the db and timezone for user profile and calculate it on the fly.
I read raw data (UTC timestamps) from the db and timezone for user profile and calculate it on the fly.