| 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: | Whole Thread | Raw Message | 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 |