2 ms·
Thanks. Exactly. With your simple example, I now don't know why I've had such a hard time articulating it. Since "events" arrived whenever, we also added a "re
by specialist 7y ago
Thanks. Exactly. With your simple example, I now don't know why I've had such a hard time articulating it.
Since "events" arrived whenever, we also added a "received" timestamp. Great for debugging. Necessary for compliance. ("What did you know and when did you know it?")
We had some clever indices on the timestamps, so queries remained performant. (Sorry, I'd have to lookup the details, names of things.) Not being a DBA, I eventually learned the trick was to properly normalize to avoid GROUP BY, and so forth.
Thanks again.