From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Daniel Díaz <diaz(dot)carrete(at)gmail(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: SSL slow when using libpq.dll |
Date: | 2014-04-16 12:15:56 |
Message-ID: | 534E747C.10801@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
(2014/04/15 5:06), Daniel Díaz wrote:
> 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?
Yes.
> - Is it normal that using sspi is that much faster?
I can't think of the reason.
> - 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?
No.
> - Can deleting libpq.dll cause problems?
Some authentication methods may be unavailable.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | PG User | 2014-04-16 23:24:37 | compiling ODBC on windows |
Previous Message | 张兴宇 | 2014-04-16 08:52:26 | Does pgsql-odbc driver have a 32bit version? |