Hi,
When selecting and fetching 500.000 records with about 46 columns with only number and varchar2 col types. The speed difference is consistent about x2 slower with direct mode. (~5.3 sec. vs ~11.8 sec.in 32bit - 5.2 sec vs. 8.6 sec in 64bit)
Why? Does direct mode not support network compression?
Are there any plans on improving direct mode transfer speed?
OCI vs Direct Mode fetch speed difference - compression?
Re: OCI vs Direct Mode fetch speed difference - compression?
We're currently investigating the issue. To pinpoint the cause of the peformance deterioration, we need an example demonstrating the difference in data retrieval speed between OCI Mode and Direct Mode, and the DDL script for the table used in the example. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html