Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

In the SQL Anywhere 12 - documentation (http://dcx.sybase.com/index.html#1201/en/dbadmin/connect-s-3835923.html) says that:

Using dbping -s can be useful to give an indication of whether communication compression may improve performance.

Is there a formal (or heuristic) rule, which, depending on the "Total Time" & "Average" - values ​​of the "Round trip simple request", "Send throughput" & "Receive throughput" - parameters tells whether to use communication compression?

asked 26 Apr '13, 05:42

Ilia63's gravatar image

Ilia63
1.2k515782
accept rate: 44%

edited 26 Apr '13, 07:49

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


No, I know of no such heuristic.

I'd guess if all of the following are true (and these are ballpark estimates):

  1. your send or receive throughput is slow (say 512KB per second or slower)
  2. you are dealing with blobs, fairly large values or medium to large result sets
  3. your data is fairly compressible
  4. both your client and server have available CPU (i.e. neither is already at 100% CPU)

then communication compression is likely to improve your performance. Note that I wouldn't recommend communication on a LAN. But the only way to know for sure is to try it.

See http://dcx.sybase.com/index.html#1201/en/dbadmin/using-compression-perform.html

Hope this helps.

permanent link

answered 29 Apr '13, 09:00

Ian%20McHardy's gravatar image

Ian McHardy
3.4k23557
accept rate: 40%

edited 29 Apr '13, 09:03

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×438
×275
×14
×13

question asked: 26 Apr '13, 05:42

question was seen: 2,096 times

last updated: 29 Apr '13, 09:03