Domingo Garcia Member Licensed User Jun 30, 2018 #1 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.
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.
K keirS Well-Known Member Licensed User Longtime User Jun 30, 2018 #2 Which JDBC driver ate you using? If it's the MS one try setting responseBuffering="full" in the connevtion string. Upvote 0
Which JDBC driver ate you using? If it's the MS one try setting responseBuffering="full" in the connevtion string.
Domingo Garcia Member Licensed User Jul 1, 2018 #3 Hi I'm using " jtds-1.3.1" driver. Should I replace it Upvote 0
Don Oso Active Member Licensed User Longtime User Jul 1, 2018 #4 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 Upvote 0
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 B4X founder Staff member Licensed User Longtime User Jul 1, 2018 #5 You should post the relevant code... Maybe you are doing something wrong / inefficient. Upvote 0
K keirS Well-Known Member Licensed User Longtime User Jul 1, 2018 #6 Domingo Garcia said: Hi I'm using " jtds-1.3.1" driver. Should I replace it Click to expand... I would. JTDS has had no major updates for a long time. Upvote 0
Domingo Garcia said: Hi I'm using " jtds-1.3.1" driver. Should I replace it Click to expand... I would. JTDS has had no major updates for a long time.