TOracleDataSet.CompressBlobs

[GI]

Hello Marco

I need to store in my database many large Blobs and the TOracleDataSet.CompressBlobs property sounds great regarding the size-control of my database. I want to use a TOracleQuery (not a TOracleDataSet), since it's a lot of faster than a TOracleDataSet and there's no need for navigation (simple INSERTs and UPDATEs). Is there any way of using a TOracleQuery with a corresponding CompressBlobs directive (both in Inserts/Update and Select) ?
Using a TOracleDataSet, what's the optimal or usual Compression Factor value ?

Thanks in advance for your reply

Best Regards

G.Mytskidis

 

[Marco Kalter]

Is there any way of using a TOracleQuery with a corresponding CompressBlobs directive (both in Inserts/Update and Select) ?

No, but since you are in complete control of the DML statements, you can easily use Delphi's ZLib unit to compress and decompress your data.

Using a TOracleDataSet, what's the optimal or usual Compression Factor value ?

A factor 2 is typical, but it depends on the nature of your data,