What is cmaxpktsz good for in Sybase

Question

What is cmaxpktsz good for in Sybase?

Answer 1

cmaxpktsz the same to the parameter "maximum network packet size" that you can see by sp_configure. I advise only updating its value by sp_ configure. If several of your applications send or receive huge amounts of data across the network, such applications can achieve important performance improvement through using larger packet sizes. Two illustrations are large bulk copy operations and applications writing or reading large text or figure values. Generally, you want to keep the value of default network packet size small for users performing short queries, and allow users who send or receive large volumes of data to request larger packet sizes by setting the maximum network packet size configuration variable.

caddnetmem the same to the parameter "additional netmem" the same you can see by sp_ configure. Again, I advise only updating this value by sp_ configure. "Additional netmem" sets the maximum size of additional memory which can be used for network packets which are larger than ASE's default packet size. For additional netmem the default value is 0 that means that no extra space has been assigned for large packets. Noticed the discussion below, in maximum network packet size, for information on setting such configuration variable. Memory allocated along with additional netmem is added to the memory allocated by memory. This does not influence other ASE memory uses.