Skip to main content

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

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

SPSS Modeler

Modeler


Software version:
14.2, 15.0


Operating system(s):
Solaris


Reference #:
1616814


Modified date:
2013-02-01

Translate my page

Content navigation