JDBC very slow with studio 6 on mac

[Dave Jobling]

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://192.168.2.30:59999

 

 

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.

 

Thanks

 

Dave Jobling