PM97854: ODBC PERFORMANCE: SAVE TRANSLATE TO MS SQL SERVER 2008 IS UNBELIEVABLY SLOW

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • You have:
    Create ODBC data sources to MS SQL Server 2008 using:
        IBM SPSS OEM 7.1 SQL Server  Wire Protocol
        IBM SPSS OEM 7.1 SQL Server Native Wire Protocol
        SQL Server  (MS default driver installed with Win 7)
    Use these data sources to export the 10M row by 10 column
    dataset to a table in MS SQL Server.
    
    Regardless of driver, regardles of tweaks added to the SQL built
    by the Database Wizard, the SAVE TRANSLATE /TYPE=ODBC export
    goes excruciatingly slow (something like 100 rows every 3-4
    seconds)
    

Local fix

  • The issue seems less to do with the particular ODBC Driver and
    more to do with the actual mechanism of the SAVE TRANSLATE
    command.  IBM SPSS Statistics Development is evaluating this
    problem now and assessing the different approaches for how to
    handle it, including design changes within the product. This
    issue is most likely to be addressed in a future release of the
    product.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ODBC PERFORMANCE: SAVE TRANSLATE TO MS SQL SERVER 2008 IS    *
    * UNBELIEVABLY SLOW                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ODBC PERFORMANCE: SAVE TRANSLATE TO MS SQL SERVER 2008 IS    *
    * UNBELIEVABLY SLOW due to the lack of a bulk loading ability  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to Statistics 23.0                            *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

  • Bulk Loading has been added to SAVE TRANSLATE for Statistics
    23.0
    

APAR Information

  • APAR number

    PM97854

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    M00

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-25

  • Closed date

    2015-03-19

  • Last modified date

    2015-03-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RN00 PSN

       UP

  • RN00 PSY

       UP



Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

22.0

Reference #:

PM97854

Modified date:

2015-03-19

Translate my page

Content navigation