#32 0.39 about ten times slower than 0.38

[Anonymous]

0.39 forces the use of 'Cursor' object to get results; calling fetchall() or fetchone() is about ten times slower than 0.38.
I have only tested over a WAN.

Example: this example runs on both 0.38 and 0.39, but takes much longer on 0.39:

import Sybase, sys

print syb.__version__
syb = Sybase.connect( 'MYSERVER', 'myuser', 'mypass', 'mydatabase' )print Sybase.__version__
cursor = syb.cursor()
cursor.execute('select * from some_table' )
print cursor.fetchall()

tested on Sybase 15.0.2

[Andrei Gnepp]

See https://sourceforge.net/mailarchive/forum.php?thread_name=4A96486E.1000203%40users.sourceforge.net&forum_name=python-sybase-misc

I've found the following workarounds to be effective:

cursor.execute('select * from some_table' , select=False)
cursor.execute(' select * from some_table' )

(In the second one, the sql starts with a space.)