Improving performance in accessing Sybase IQ

Workaround: To improve performance, you can do one of the following:

• Use the IQ Loader File via Load Table and IQ Loader DB via Insert Location loader components to speed up loading into Sybase IQ.

• Use Adaptive Server Enterprise, Adaptive Server Anywhere, or Microsoft Access instead of Sybase IQ for the staging portion of your project.

• If you still want to use Sybase IQ for staging, split the project into new staging and loading projects. Use DB Bulk Load Sybase IQ instead of DB Staging in the new staging project and use IQ Loader File via Load Table and IQ Loader DB via Insert Location to speed up loading into Sybase IQ in the new loading project.

• Use IQ Loader File via Load Table component for loading binary data that are extracted from Sybase IQ. You must create a custom script to do the binary extract from a Sybase IQ table, using isql utility:

  • Extract Data on Source IQ system

    set TEMPORARY OPTION Temp_Extract_Name1='C:\myfolder\mybinfile.bin';
    

    set TEMPORARY OPTION Temp_Extract_Binary='ON';
    

    SELECT * FROM mytable
    

  • Create a custom load script in IQ Loader File via Load Table component by setting a dummy file name in the Text Source property window.

    LOAD TABLE mytable
    {
    [myCol1] BINARY WITH NULL BYTE,
    	[myCol2] BINARY WITH NULL BYTE,
    	[myCol3] BINARY WITH NULL BYTE
    )
    FROM '<path&filename on destination system>'
    QUOTES OFF
    ESCAPES OFF
    FORMAT binary
    

  See Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ 12.7 System Administration Guide.