Post reply

Openquery to oracle take along time why?

  • December 25, 2016 at 3:16 am

    #316985

    if i run this in oracle , also throw network its took 0.24 sec , very qucick

    "select SEQ_ID, FCLTY_ID, ACTION_CODE, SKU_ID, SKU_DESC, UPC, INNER_PACK_QTY, "GROUP", LOCN_ID, IS_DOWNLOADED, DOWNLOAD_DTIME, DOWNLOAD_INFO, CREATE_ID, CREATE_DTIME, MODIFY_ID, MODIFY_DTIME

    from xfer_in_sku xsku

    order by xsku.seq_id"

    but if i run it from openquery itd took 4 mintues - why?

    select * from openquery(LinkedSRV,

    'select SEQ_ID, FCLTY_ID, ACTION_CODE, SKU_ID, SKU_DESC, UPC, INNER_PACK_QTY, "GROUP", LOCN_ID, IS_DOWNLOADED, DOWNLOAD_DTIME, DOWNLOAD_INFO, CREATE_ID, CREATE_DTIME, MODIFY_ID, MODIFY_DTIME

    from xfer_in_sku xsku

    order by xsku.seq_id')

    plz help

    thanks

  • December 30, 2016 at 2:54 am

    #1920062

    I have not tried to link to an Oracle server, but this is most likely a driver issue.

    Maybe some of the Oracle table columns are of types that aren't completely compatible to the SQL Server field types and thus need to be implicitly converted?

    Just guessing! 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply