From: | Daniel Díaz <diaz(dot)carrete(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | SSL slow when using libpq.dll |
Date: | 2014-04-14 20:06:03 |
Message-ID: | CAEdN0yieMWx2keDb-9H_SWQgMmVENLhVuDbbm7YxMzTZgB6Z-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I'm using psqlodbc on Windows to perform a query that returns on the order
of 1 million rows.
I have noticed that, when the DSN is configured to use SSL, the query runs
very slow, like three times slower.
However, if I delete libpq.dll from the psqlodbc installation directory,
the slowdown in the SSL-secured query is much less (only about 10-20%
compared to the unsecured query).
I have tried several of the latest versions of the driver, and the same
thing happens in all.
Several doubts:
- I surmise that the absence of libpq forces the driver to use Windows'
sspi service to handle the SSL, is that correct?
- Is it normal that using sspi is that much faster?
- Is there a way, other than deleting libpq.dll, to force the use of sspi
on Windows when using the compiled distribution of the driver?
- Can deleting libpq.dll cause problems?
Thanks in advance,
Daniel Díaz
From | Date | Subject | |
---|---|---|---|
Next Message | Andrzej Jurzec | 2014-04-16 07:11:21 | psql odbc and ado |
Previous Message | Scott Urban | 2014-04-14 15:46:25 | Re: Installing ODBC |