We want to use Event Store in our basket as a data store.(for all reads) We create a unique stream for each basket aggregate and then we append all the events we created to this unique stream. Also, we create a projection for each stream and we make all our basket queries using these projections. We have 3 different event store clusters. we use linker for data synchronization. We are getting very slow response to our queries. If we are making a stupid mistake, would you please share your valuable ideas with me?
I am sharing a simple example with you below.
(i.e. http://127.0.0.1:2113/projection/projection-basket-492a4e98-43c3-47e2-bad4-611f32d9440d/result => 1.8 sec response time (avg.) / 1 K Concurrent read query)
Sample Projection :