JDBC very slow with studio 6 on mac

Dave Jobling omnisstuff at tynedalecomputers.com
Mon Dec 5 04:56:21 EST 2016

Hi All


I have been running some speed comparisons using JDBC to connect to a
Microsoft SQL database on a local network.  Using Omnis studio the jtds
driver took 28 seconds to select 32000 records and the Microsoft JDBC driver
took 26 seconds.


The same query using the same drivers was run using the Squirrel SQL Client
app.  This only took 4 seconds to select the same data.  I also tried the
Actual Tech odbc driver using omnis and that only took 4 seconds as well.


For the jtds driver I am connecting to the database with the following..


DriverName : net.sourceforge.jtds.jdbc.Driver


Logon string :  jdbc:jtds:sqlserver://



I'm trying to figure out why the JDBC driver is so slow when using omnis.
I'm assuming there is some parameter which needs to be included to it speed
up.  I suspect omnis is retrieving just a few records at a time instead of
the whole lot in one go.


If anybody can shed any light on this I'd appreciate it.




Dave Jobling





More information about the omnisdev-en mailing list