B4J Question Jdrc 2 load question

[John Decowski]

Has anyone done any load testing on jdrc? I'm developing an app that uses a cloud database for all inquiries. I need to know a. If anyone has determined how many unique requests 1 sever instance can handle(mysql database). B. If i were to load test my self how would one go about it ?

Thanks in advance
John

 

[DonManfred]

[Server] Performance measures

B4J server library is based on an open source project named Jetty. Jetty server performance is excellent which means that B4J server performance is also excellent. The following numbers are the result of a simple test where one program sends many requests to the server program. Both running on...

www.b4x.com

 

[John Decowski]

[Server] Performance measures

B4J server library is based on an open source project named Jetty. Jetty server performance is excellent which means that B4J server performance is also excellent. The following numbers are the result of a simple test where one program sends many requests to the server program. Both running on...

www.b4x.com

Appreciate the fast response. Any idea how many unique users will be mathematically able to access each server simultaneously? I'm sorry, network logistics isn't my specialty.
Thank you

 

[OliverA]

Has anyone done any load testing on jdrc?

It's been a while. See https://www.b4x.com/android/forum/t...ltiple-request-stress-test.130575/post-822247

The test batch files used can be found here: https://www.b4x.com/android/forum/t...session-id-in-jrdc2-client.108642/post-679054

The modified jRDC2 for testing can be found here: https://www.b4x.com/android/forum/t...rdc2-testing-server-code-dump.128258/#content

 

[OliverA]

Any idea how many unique users will be mathematically able to access each server simultaneously?

From the previous testing I have done (on a local 1Gb network), I saturated the network without really causing jRDC2 to sweat. So your bottleneck may be network connection, not the performance of jRDC2 itself.

 

[John Decowski]

From the previous testing I have done (on a local 1Gb network), I saturated the network without really causing jRDC2 to sweat. So your bottleneck may be network connection, not the performance of jRDC2 itself.

Thank you for your reply, I'm planning on building an app for personal finance. The database will be accessed (hopefully) from tens of thousands of people. I understand I will need to scale up eventually with load balancing. The database server will be cloud hosted on at least a 1 gigabit server. I was more of less just making sure what I needed to do to allow many unique connections at a time.