About jtdawso1

jtdawso1

Hello,For a bit of context, I'm using ASE 16.0 SP03, an up-to-date copy of libsybdrvodb.so, Python 3.8.10, and an up-to-date copy of pyodbc ( https://github.com/mkleehammer/pyodbc )I found a strange issue when running a simple "select" query through ...

jtdawso1

I just had a breakthrough: if you just add the line "conn.setencoding(encoding='iso-8859-1')", it appears that the "LONGBINARY" type issue disappears, and the query executes near-instantly. I'm investigating further now, I'll edit this comment once I...

jtdawso1

Hey Ryan, thanks for that comment. That's given me a little bit of a lead--the file that Ribo translated says that my filename has been auto-translated to a "LONGBINARY" type. Indeed, when I run "select * from files where filename=convert(varchar(100...

jtdawso1

For anyone visiting this page in the future, this thread is related: https://community.sap.com/t5/technology-q-a/pyodbc-runs-quot-select-quot-queries-very-slowly-when-providing-parameter/qaq-p/14075794It appears that the issue is caused by pyodbc enc...

jtdawso1

One other note for investigation purposes: you noticed that the "SELECT" statement didn't perform differently between your two DYNAMICPREPARE=1 tests. Well, I've found in some extra testing that this difference only exists when querying large tables ...

jtdawso1

Thank you for the extensive comment! A lot to chew on there, I'm playing around with things now, but that last bit you said about "we remove the exec part of the query" is very interesting! It appears that, for a simple solution, one can just add DYN...

User Statistics

User Activity

pyodbc runs "select" queries very slowly when providing parameter

Re: pyodbc runs "select" queries very slowly when providi...

Re: pyodbc runs "select" queries very slowly when providi...

Re: ASE 15.5 Poor performance from ODBC

Re: pyodbc runs "select" queries very slowly when providi...

Re: pyodbc runs "select" queries very slowly when providi...