JDBC very slow with studio 6 on mac

IT it at plastipol.com
Tue Dec 6 03:40:05 EST 2016


Hi Dave,

Did you read jTDS http://jtds.sourceforge.net/faq.html

Look for "Read What is the URL format used by jTDS?"

There are a few parameters to play with that perhaps can improve speed.


regards

xavier



El 05/12/2016, a las 10:56, Dave Jobling <omnisstuff at tynedalecomputers.com> escribió:

> 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
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com





More information about the omnisdev-en mailing list