Devart Forums

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?

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