I am using
EventStore to store events that affect account holdings for a business that
invests for their clients in equities. A
holding is identified by the combination of account id, security id, and
holding type (long or short). Currently,
the events for each holding (e.g. account1 bought x shares, account1 sold x
shares, etc…) are held in separate streams.
A projection calculates the current quantity of shares for any of the holdings. Each account may have several hundred
I need to
provide in a report and/or user interface grid which displays all the current
holdings of any of the accounts. A user
would specify the account and then submit the request. I’m able to generate a table like this from
the client by repeatedly invoking my projection for each of the holdings in the
account using WebClient().DownloadString(projectionUrl). However, the time required to generate this
result is longer than I can expect a user having just clicked a button to
I’d like to
solve this problem by using the capabilities of EventStore, if possible, but so
far I haven’t been able to come up with anything. Are there any strategies for creating this
sort of result that have worked for others?
Are there any examples of this I could see?