Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Performance while Reading and writing blobs


    I m writing blobs into an Sybase 12.5 database.
    No matter what I m doing, I never cross 1 M/Bit traffic. This seems a bit slow for me, because I m using a 100 M/Bit net.

    Does anyone know how to configure the Sybase DB to get it work faster ??

    Any help woulf be appreciated!

  2. #2
    Join Date
    Dec 2003
    I've never worked with blobs. However, based on your indication that network traffic is an issue I'm making a blind assumption that you're trying to BCP data into Sybase from somewhere on the network.

    Several things will hamper you for large IO.

    1. Indexes on the target tables should be dropped prior to BCP - then recreated once the BCP finishes.

    2. Sybase's Network packet size should probably be at the maximum of 16384. This will also mean raising sybase's "additional network memory".

    Hope I'm not totally off base here.

    Good luck.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts