B4J Question MS SQLServer Performance

Discussion in 'B4J Questions' started by Domingo Garcia, Jun 30, 2018.

  1. Domingo Garcia

    Domingo Garcia Member Licensed User

    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.
     
  2. keirS

    keirS Well-Known Member Licensed User

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

    Domingo Garcia Member Licensed User

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

    Don Oso Member Licensed User

  5. Erel

    Erel Administrator Staff Member Licensed User

    You should post the relevant code...

    Maybe you are doing something wrong / inefficient.
     
    Harris likes this.
  6. keirS

    keirS Well-Known Member Licensed User

    I would. JTDS has had no major updates for a long time.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice