Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread blob compression, remotecompression question
Mon, Nov 27 2006 1:59 PMPermanent Link

"Lucian"
Hi,

If I have a BLOB field set to compressed and also set the property
RemoteCompression of a session, how does that actually works when the
BLOB is sent out from the server? It will be a waste of CPU power to
compress the compressed BLOB, right? So how does the server handle this
scenarion?

--
regards,

Lucian
Tue, Nov 28 2006 11:56 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Lucian,

<< If I have a BLOB field set to compressed and also set the property
RemoteCompression of a session, how does that actually works when the
BLOB is sent out from the server? It will be a waste of CPU power to
compress the compressed BLOB, right? So how does the server handle this
scenarion? >>

Actually the BLOB is decompressed when it is read on the server, compressed
for the transport over the wire, and then decompressed on the client for
access.  It's on our list to address the decompress/compress step on the
server, but it's a little harder than you might think because one is
completely separate from the other in terms of the engine code, and there
are cases on the database server when opening compressed BLOBs *does*
require decompression, such as with triggers or server-side procedures.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image