Ivanlei
01/18/2020, 3:02 PMsnapshot=true
on our eventing queries and measured a 5X increase in the events per second throughput of process_events
before we saw events buffers overflowtheopolis
01/18/2020, 3:06 PMprocess_events
look similar to select * from process_events
or are they more complex?Ivanlei
01/18/2020, 3:06 PMtheopolis
01/18/2020, 3:07 PM_events
tables and turn on snapshot=True
for you (I am going from memory though)Ivanlei
01/18/2020, 3:08 PMtheopolis
01/18/2020, 3:08 PMzwass
01/18/2020, 6:02 PMevents_optimize
on, then we can probably skip the diffing step on a differential query to an event-based table... the results should all be "added".Ivanlei
01/18/2020, 6:03 PMremoved=true
on our event queries and had events_optimize=true
. it surprised me how much of a difference snapshot=true
made for the audit data.zwass
01/18/2020, 6:06 PMIvanlei
01/18/2020, 6:08 PMzwass
01/18/2020, 6:09 PMIvanlei
01/18/2020, 6:16 PMevents_optimize
that introspects the query on a specific event table. potentially a cheap spot to simply flip the snapshot
option on for the ScheduledQuery
zwass
01/18/2020, 6:26 PMIvanlei
01/18/2020, 8:58 PMsnapshot
would even go a long way