Blob compressing

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Tue Oct 27 12:49:43 CDT 2009


On 10/27/09 9:26 PM, "Stan Busk" <maxprog at mac.com> wrote:

Fail if to assign it in the constructor?

If yes, try another experiment:
    assign that field

    mydb.open
    mydb.myTbl.VyBlobField.IsCompresses = true

    ... Rest app

> All functions fail for me here. If I use VBLOB.FromFile() what I get
> with VBLOB.ToFile() is just part of the original file. My cod is quite
> clean, I am storing pictures, I get the same effect or worse on all of
> them. Anything I should know?
> 
> Stan
> 
> 
>> On 10/27/09 8:08 PM, "Stan Busk" <maxprog at mac.com> wrote:
>> 
>> Hi Stan,
>> 
>>> Ok but it looks like you can't set that as part of the constructor:
>>> http://www.valentina-db.net/dokuwiki/doku.php?id=valentina:products:adk:api:
>>> vb
>>> lob_class:construction_methods
>>> 
>>> I guess I will have to use: fldBlob.IsCompressed = true like:
>>> 
>>>         myDatabase.myTable.myBlobField.IsCompressed = True
>> 
>> You need SET this only once!
>> No need assign it before each WRITE to BLOB.
>> 
>> I think you can try assign this property in your constructor.
>> 
>>>         myDatabase.myTable.myBlobField.WriteRawData( myData )
>>>         myDatabase.myTable.UpdateRecord()
>>>         myDatabase.myTable.Flush()
>>> 
>>> Is this correct? I guess it is...
>> 
>> In fact compression for raw BLOB field on DB level do not have big
>> sense.
>> Because you self can easy compress/uncompress raw data.
>> 
>> Compression in Valentina was added mainly for TEXT field.
>> Here it is very important, because engine yet need to build index,
>> So it should self be able do compression of TEXT.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list