Thread: [ODBC] SQLGetTypeInfo tiny column sizes

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

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.