freddyertl
freddyertl
The Firebird server runs on Windows Server 2012R2 and the application runs on Ubuntu (which is a VM running on Hyper-V 2019).
I know that it sounds weird and we really tried hard to rule out any differences. We create two new VMs from scratch, installed the respective Ubuntu version with everything...
There is a difference for `/proc/sys/net/ipv4/tcp_rmem`: Ubuntu 14 (fast) 4096 87380 6291456 Ubuntu 20 (slow) 4096 131072 6291456 The values for `/proc/sys/net/core/rmem_default` are identical. We haven't tested setting the `socketBufferSize`...
What are reasonable values for `socketBufferSize` that we should test?
And the syntax is `jdbc:firebirdsql:localhost/3050:testdb?charSet=UTF-8&socketBufferSize=16384` ?
The results are really weird. Changing the parameter made the whole thing even faster on Ubuntu 14. From like ~18 seconds down to 10 seconds. But for Ubuntu 20 it...
We have only configured IPv4 and we forced the same memory and garbage collector. I think using a different tool sounds like the next logical step. Let me try this...
Okay, I made some progress. As @AlexPeshkoff suggested, I installed the Firebird client on both machines and used isql to do the same test. The database I'm connecting to is...
Yes, I used isql for the test. I increased the number of records to 3500 to see something in Ubuntu 14. Here are the results: Ubuntu 14: `select ID, NEW_BLOB...
Don't you think it would be worth investigating this given that Ubuntu 20 is a widely used distro?