B4J Question MS SQLServer Performance

[Domingo Garcia]

I had a program that ran in VB6 that extracted data from a MS SQLserver and it ran in about 5 mins. I converted it to B4J and it takes almost 45 mins. Is there any tunning that can be done to improved the performance of SQL access using B4J.

 

[keirS]

Which JDBC driver ate you using? If it's the MS one try setting responseBuffering="full" in the connevtion string.

 

[Domingo Garcia]

Hi I'm using " jtds-1.3.1" driver. Should I replace it

 

[Don Oso]

Try this one : sqljdbc42.jar works with MSSQL SERVER 2008 and others.



https://www.microsoft.com/en-us/download/details.aspx?id=54671
https://www.microsoft.com/en-us/download/details.aspx?id=54671
For newer versions here : https://docs.microsoft.com/en-us/sq...bc-driver-for-sql-server?view=sql-server-2017

 

[Erel]

You should post the relevant code...

Maybe you are doing something wrong / inefficient.

 

[keirS]

Hi I'm using " jtds-1.3.1" driver. Should I replace it

I would. JTDS has had no major updates for a long time.