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