HNHacker News
TopNewBestAskShowJobs

daniel56hdz

1 karma · joined March 11, 2018

submissionscomments
daniel56hdz··on Help on database for efficient group bys
Could you please expand on this more? I could really use the understanding!
daniel56hdz··on Help on database for efficient group bys
Yes these tables have indices but it doesn’t mean much once we try to find the earliest dateTime for each device using a group by.
daniel56hdz··on Help on database for efficient group bys
Yes, the significance of the “specific_date_time_value” is that certain users will want to query based on that to determine if it’s a device that they should remediate. A large percent of the queries though would be based on now() vs a specific date.

In all of these approaches the issue occurs when I add the grouping stage as it doesn’t seem to be a way to just get the earliest value for each device without reading all records for each device.

Could you explain the queue to surface the next event easily?