Use of the Oracle Wire-protocol ODBC driver is taking almost a factor of 2 times longer to download data

Technote (FAQ)


Question

When comparing the Oracle wired protocol ODBC driver against the Oracle non-wired protocol driver, the wired protocol driver is taking almost twice as long to bring back the same data within Modeler. Both of these drivers can be acquired through the SDAP 6.1 package provided by IBM SPSS.

Cause

Unknown

Answer

Although the non-wired protocol ODBC driver is provided through SDAP it is not supported by Modeler.

Do not rely on this ODBC driver for use in Modeler. The wired protocol driver provided by SDAP is supported by Modeler. This driver may reflect slower performance over the Oracle client based non-wired based ODBC driver.

Additional information may be obtained through DataDirect's website to tailor ODBC drivers setting to your environment.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Modeler
Modeler

Software version:

14.2, 15.0

Operating system(s):

Solaris

Reference #:

1616814

Modified date:

2013-02-01

Translate my page

Machine Translation

Content navigation