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

    Unanswered: Performance while Reading and writing blobs

    Hi,

    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
    Posts
    44
    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.

    Isaac

Posting Permissions

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