We are looking at using the event store to store large volumes of events that are generated by a trading system. There will likely be around a million streams, each containing potentially millions of events. The event store looks like it would be a good solution to persisting this data.
However before we dive to deep into proof of concept, we have a few basic questions:
- Is the event store suitable for this type of activity, and/or has anyone made use of it for this?
- As storage cost will be critical for us, how does the data size compare to compressed raw data (zipped csv for example)
- Can single streams by dumped to an archive, removed, but restored on demand when the data is required?
Any thoughts on this would be much appreciated