Hey @pckeyan.

Can you please share your benchmark setup or a simple project which let me reproduce your issue | understand the setup behavior?

Cheers,
Oleh

Hi @OlegDokuka,

I used directly into my business service, Let me try to peel it out. But from the environment standpoint, I used one Cassandra Docker container running on AWS EC2 - c5n.18xlarge. Same Backend Codebase to connect to Cassandra.

http Rest Call (API) - 800 TPS
Non Blocking Http (API) - 1600 TPS
RSocket(One Connection/Server) Connection Cache at Client - 300 TPS

I used the same code we tested on Issue 177 as mentioned above and I am using the Reactive Spring Cassandra with Datastax driver.

I'm asking because of different prefetch setup which may vary between reactive and blocking implementations in Spring.

Also, you point to a sample project, but it would be much better to have a simple client which can show RPS per a client

Definitely let me put together one for you to check. But if I remove the Cassandra and mock the data, I am getting ~5000 TPS. Something is blocking to Cassandra.

So, if you look at my slides on reactive database access, and in particular on the slide 33, which shows how reactive Cassandra works underneath, you may get an idea, why it may be slow, especially if backpressure is applied

Thank You, Let me go through the slide and will get back to you.

@OlegDokuka I tried to modify the fetchSize it has no effect. Let me try to get a sample for you to check.

@pckeyan any updates?

@OlegDokuka I tested with different parameters and I do not see any improvement. If you wish we can close this issue for now. I will reopen once I have a sample because I was testing this in my business application.

@pckeyan marking as need information. Feel free to provide a sample when it is ready

@OlegDokuka I added you as.a collaborator to my private projects. Please check this readMe for instructions. https://github.com/pckeyan/rsocket-load-balancer/blob/master/README.md. Please let me know your feedback.

@pckeyan looking

Hi @OlegDokuka, Any findings so far?

@OlegDokuka I removed my load balancer component and used LoadBalancedRSocketMono in my Client and directly called Server has increased the throughput to 980 transactions per second. So 3x increase if I remove the component. Any insights or findings? But still this is less than non-blocking http rate.

Hey. I still was not able to look due to hard work on the upcoming release, however, I'm not recommending to use a load-balanced RSocket for now.

I hope I will give you some updates shortly

Sure @OlegDokuka I Understand and will wait for your comments.

Just a gentle reminder @OlegDokuka

@OlegDokuka In the mean time, I tried with Postgresql. The RPS is at the same level of around 200-300. I tried with R2DBC but it is behaving weird. So could not complete the test with r2dbc. Can you please explain why the throughput is very low?

@pckeyan

do you mean HTTP vs RSocket on the pure JDBC is on the same level? If yes, I guess this can be simply DB limitation to have that number of requests per sec, I'm wondering what is the performance of the same without a network at all.

And is the second question related to jdbc vs r2dbc?

@OlegDokuka Either Cassandra or Postgresql, the throughput is same around 200 - 300 RPS. This is way less compared to HTTP (800 RPS), These testing is on same local device. The test uses JDBC. Cassandra states that it can support upto 80K RPS with One connection. For Postgresql, I increased the connections, but no success. Can you please test against a database and provide some metrics to compare?

R2dbc - When I tried with it, it is not even fetching data after a loop. I need to dig into it.

@OlegDokuka Any benchmark available against a database backend? Can you please share a sample? Please let me know your recommendations.

@OlegDokuka Any help here?