Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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.2k545982
accept rate: 44%

edited 26 Apr '13, 07:49

Mark%20Culp's gravatar image

Mark Culp
25.0k10142298


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:

×439
×276
×14
×13

question asked: 26 Apr '13, 05:42

question was seen: 2,234 times

last updated: 29 Apr '13, 09:03