ODBC/Large column performance problem

From: <micjohnson_at_logicon.com>
Date: Mon, 21 Jun 1999 22:32:07 GMT
Message-ID: <7kmeh7$nnh$1@nnrp1.deja.com>

Situation: We are running Oracle Server 7.3.3, Oracle ODBC Driver2.573.3513. We have a table that has a large "LONG RAW" column -- typically 32K - 1MB per entry. When using an ODBC MoveNext() call, it takes around two seconds to step between each row (even on the 32K entries). We have no other performance problems in our system to speak of. I am wondering if there are any size settings that would improve this? Are there any ODBC cache settings that should be changed? Or any Oracle cache settings? Has anyone else ever seen this performance problem?

Thanks!
Mike Johnson

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 21 1999 - 17:32:07 CDT