Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Compression Advice
Wed, Mar 12 2008 12:46 PMPermanent Link

edhrx
Hi,
I am migrating an application off mssql to ElevateDb and one of the things the application did was saved all data changes when a user posted  by
gathering together the data from a buffer record (turned all the datatypes to the string equivalent) and then used a third party compressor (
Tcompress ) to compress it and then stuff it into a blob field.
Ok...In the ElevateDB app because everything is a string should I just put it into CLOB and let ElevateDb handle the compression
Would I get better compression ?

best wishes Ed.


Wed, Mar 12 2008 3:44 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ed,

<< Ok...In the ElevateDB app because everything is a string should I just
put it into CLOB and let ElevateDb handle the compression Would I get better
compression ?  >>

You'll probably get at least as good of a compression result.   Plus, you'll
avoid having to worry about the compression from the standpoint of any
accessing applications, which will simply just see the data as a CLOB
column.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image