B4J Question Multiple server port on JRDC2, will it increase performance?

[incendio]

Hi guys,

I have a little knowledge about network.

Want to ask you, in a server with multicore cpus, if I run multiple jrdc2 server to listen to different port, will it increase performance, let say to handle about 1 billion transaction per day?

Here is the sample of the config file :

DriverClass=org.firebirdsql.jdbc.FBDriver
JdbcUrl=jdbc:firebirdsql://xxxxx
ServerPort=17770
Debug=true

 

[Erel]

jServer is multithreaded. Requests are handled by an internal thread pool. No need to run multiple instances of jRDC2.

With jRDC2 the bottleneck is likely to be the database server.

 

[amorosik]

One billion/day is 12K transaction every single second
The estimated data below is indicative and based on standard Intel i7 CPU at 3000MHz
ChatGpt says:

At the end of the reply chatgpt says:
"..but what do you need all these tps for?.." .

 

[Erel]

And some numbers from an old computer of mine: https://www.b4x.com/android/forum/threads/server-performance-measures.37502/#content

 

[amorosik]

The topic of high performance is very interesting
Let us know what you choose, the experience could be useful to others too

 

[incendio]

One billion/day is 12K transaction every single second
The estimated data below is indicative and based on standard Intel i7 CPU at 3000MHz
ChatGpt says:

View attachment 161918

At the end of the reply chatgpt says:
"..but what do you need all these tps for?.." .

Wow, I use Firebird SQL, it it the slowest one

 

[amorosik]

...I use Firebird SQL...

Me too