OCI vs Direct Mode fetch speed difference - compression?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

OCI vs Direct Mode fetch speed difference - compression?

Post by dados » Fri 26 Jun 2020 15:28

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?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: OCI vs Direct Mode fetch speed difference - compression?

Post by MaximG » Fri 10 Jul 2020 16:13

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

Post Reply