What is cmaxpktsz good for in Sybase
What is cmaxpktsz good for in Sybase?
Expert
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.
Describe why XML is a better markup language than HTML?
Why Increase correct timeslice -201?
Contrast a network and hierarchical database model?
Why use references quite than pointers within the public API, mainly for arguments that are modified?
Explain how is the HASH file used and where we can use it?
What is Redundant Array of Inexpensive Disks controller technology?
Describe the term Java bean?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
Write down brief note on the differentiation between dynamic cache and static cache?
Illustrates the term Open Server in Sybase?
18,76,764
1926453 Asked
3,689
Active Tutors
1449789
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!