Hi,
Currently working on a project where I need to access Oracle Database Server. The connection goes through a VPN tunnel, but with DBeaver it's terribly slow to fetch data. e.g.: Theres a table with 896 rows, with DBeaver it takes almost a minute to fetch the data. I also installed SQLServer on my laptop and from that one, it takes only 0.9 seconds if the table has CLOB columns.
If there are no CLOB columns ~1000 rows retrieved within 0.152s with DBeaver.
I suspect some jdbc driver settings could be the problem, but in SQLDeveloper I didn't manage to extract the configs so I could apply the same configs in DBeaver.
I also collected tcpdump from each tests and I can see that for DBeaver there are lot more packets and a lot with [PSH,ACK] communication while with SQLDeveloper there's no PSH just [ACK] and TCP Window related messages.
Could someone give me some hint what could be the problem?
DBeaver Version
Community Edition 24.0.3.202404211624
Operating System
macOS Sonoma 14.3 (23D56)
Database and driver
Steps to reproduce
Have a table with ~1000 records and 2-4 CLOB fields named FOO
Description
Hi, Currently working on a project where I need to access Oracle Database Server. The connection goes through a VPN tunnel, but with DBeaver it's terribly slow to fetch data. e.g.: Theres a table with 896 rows, with DBeaver it takes almost a minute to fetch the data. I also installed SQLServer on my laptop and from that one, it takes only 0.9 seconds if the table has CLOB columns.
If there are no CLOB columns ~1000 rows retrieved within 0.152s with DBeaver.
I suspect some jdbc driver settings could be the problem, but in SQLDeveloper I didn't manage to extract the configs so I could apply the same configs in DBeaver.
I also collected tcpdump from each tests and I can see that for DBeaver there are lot more packets and a lot with [PSH,ACK] communication while with SQLDeveloper there's no PSH just [ACK] and TCP Window related messages.
Could someone give me some hint what could be the problem?
DBeaver Version
Community Edition 24.0.3.202404211624
Operating System
macOS Sonoma 14.3 (23D56)
Database and driver
Steps to reproduce
Additional context
No response