CF5 vs CF6.1 Sybase slow

[biggreenegg]

I am having a performance problem with a query that was written for CF5 and has
been migrated to CF6.1. The database server is Sybase Adaptive Server 12.5.

SELECT
field_1
,field_2
,field_3
,field_4
,field_5
,field_6
,field_7
FROM
Table_1
WHERE
field_1 = 501

CF5 time=0ms
CF6.1 time=219ms

If I drop field_7 from the SELECT

SELECT
field_1
,field_2
,field_3
,field_4
,field_5
,field_6
FROM
Table_1
WHERE
field_1 = 501

CF5 time=0ms
CF6.1 time=0ms

Why?

[NicTunney]

Are you caching queries? What datatype is field7?

[biggreenegg]

No caching. Datatype does not seem to be a factor. I have tried numbers and
characters with the same result. I have also put the table in a MS-Access
database and the time for CF5 and CF6.1 are the same. I have applied CF6.1
Updater and updated the macromedia_drivers.jar to 3.4.

I believe the problem lies with the Sybase JDBC classes.