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