From: | Michael Kleehammer <michael(at)kleehammer(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | SQLGetTypeInfo tiny column sizes |
Date: | 2017-02-17 22:50:37 |
Message-ID: | 6dc568d8-2902-46cd-a248-6b7649343b20@Spark |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I’m the maintainer of pyodbc which is a Python / ODBC bridge and am getting really poor performance from psqlODBC varchar and wvarchar writes. The project has to work with all drivers so I have to use whatever the driver says - in this case SQLGetTypeInfo for these types return a column size of 255 bytes. Any writes above this size have be sent 255 bytes at a time using SQLPut, but this is obviously significantly slower.
Now, I’ve provided a way to override it, but I can’t do it automatically for people so it would be ideal if we could review what the proper value should be.
https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-PostgreSQL
Do you see any problem increasing this size in the driver?
Thanks,
Michael Kleehammer
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Apsel | 2017-02-20 13:11:58 | Issues with OUT parameters in stored procedures |
Previous Message | Jacobo Sánchez | 2017-02-17 14:12:46 | Re: Informatica and SSL connections |