Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: LDP/HVR - Use BCP Library on continuous replication when replicating to Sybase & MSSQL

Answered
Ali Habib User
  • Edited

This suggestion is a request for this feature in both MSSQL and ASE. Using Sybase as an example as its a current feature in Sybase Replication Server (SRS).

Similarly to Sybase replication server, we are requesting a feature where BCP libraries can be used in continuous replication mode when HVR is replicating to Sybase to use the BCP libraries to insert data above a certain threshold of inserts coming through.

This is similar in SRS which has dsi_bulk_copy which forces to use the BCP lib when the count is above the threshold set by dsi_bulk_threshold. Burst+Colasce here we can interpret (although slightly different) to SRS's feature called HVAR which is the combination of dsi_bulk_copy + dsi_compile_enable which changes transactional ordering similar to Burst in HVR. We would like to have a separate option where in continuous mode if the threshold is above 20 the BCP lib is utilised. This will help enhance continous replication performance. This would also bypass the __B burst tables and use the BCP library to directly to the insertion on the buisness table directly, unlike burst 

Please sign in to leave a comment.

Comments

4 comments

Date Votes
  • Mark Van de Wiel User

    Hi Ali,

    What you ask is not trivial. In continuous mode HVR streams data into the destination in the order changes were applied to the source (based on the commit order). What you ask for is for HVR to start having foresight into what is coming, so that if a sequence of inserts into the same table come in then we can switch to BCP.

    I'll have a chat with engineering about this but want to set the expectation that your request sounds a lot more trivial than the implementation would turn out to be. I will follow up as I learn more from the engineers.

    Thanks,
    Mark.

  • Ali Habib User
    • Edited

    Thank you very much for the response Mark. Completely understand that this is not a trivial request. We look forward to hearing further on this please do let us know if any further information is required 

  • Ali Habib User

    https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32518.1550/html/rsadmin_vol_2/BABHJEHD.htm


    Adding the above as a reference for David and Walter as to the request which is available in SRS 

  • Mark Van de Wiel User

    Ali,

    I have put this on the backlog for future consideration.

    At this point though we have no plans to implement this.

    Mark.