Event with starttime and endtime

EventStoreDB
1

Hello,
We recv events which have starttime and endtime. After recv endtime, event is no longer valid.

We want to use eventstore for doing event corelation on events. We also need to show the events in UI.

Lets say, a UI application comes in, it first need to show only events which are active , how can this be achieved . If we replay the events (event count can be upto 5 million in a day, it will become too slow to process.

Any suggestions

2

Keep a read model that holds “active requests”?

3

Hello,

Can you point me to it, how to create a read model, is it done in the eventstore or is done as part of the application code.

regards

4

Use subscribefrom to get events in real time insert into whatever your read model of choice SQL etc is