Results 1 to 4 of 4

Thread: sybase bcp

  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Unanswered: sybase bcp

    When I load data to sybase ASE12 on a win2k server by BCP,how I configure those sybase parameters,such as max memory,Default network packet size and Memory per worker process for a good performance?Any experience will be appreciated.thank you.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    use sp_configure sp_cacheconfig

  3. #3
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159
    It's probably worth setting the parameter "number of pre-allocated extents" to a larger value if you are going to perform a lot of bcp operations. The default is 2. It controlls how much space a BCP sessions is given each time it request space. 2 extents = 16 pages = 32K. If you are going to be loading MB of data into a table it's probably worth upping this to reduce the number of times BCP asks for space.

  4. #4
    Join Date
    Mar 2003
    Posts
    4

    Smile

    Thank you.

Posting Permissions

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