3 Replies Latest reply: Mar 12, 2012 2:20 PM by Ramesh Reddy RSS

ODBC Connection Slow

John Tan Newbie

Hi,

 

When I used ODBC driver postgres, we realize the performance is very poor vs JDBC driver. Connection took 700-800ms to established vs JDBC connection tool <2 ms. I checked there is no tracing and logging from the driver side and the configuration is the same as user guide

  • 1. Re: ODBC Connection Slow
    Ramesh Reddy Master

    John,

     

    I do not know of any known issues with connection delays using the ODBC. Typically it is about the same time as the JDBC. May be you can turn on tracing on the driver or logging the ODBC driver manager to see what is going on. Also, you can place the Teiid server on Trace and see if the request is coming immediately or not.

     

    Depending upon whether you are using Windows vs Linux the above configuration for tracing is different for the driver.

     

    Ramesh..

  • 2. Re: ODBC Connection Slow
    John Tan Newbie

    This is on windows environment. Is there a version of postgres odbc has been tested against teiid? I suspect it is the driver issue as jdbc connection is alot faster.

  • 3. Re: ODBC Connection Slow
    Ramesh Reddy Master

    I have extensively used version 8.4.0200 version before.  I used 9.x version once or twice. So, try 8.4 and see. On windows, you ODBC Driver manager you can turn on the ODBC logging as well driver traces. Note ODBC uses different port than JDBC, do you have restrictions setup on the this port on server may be?

     

    Ramesh..