CompressBLOB

[SvenHeuer]

three questions:

1. Is there anything else i have to do on compressing long-field (CompressBLOB=true

(i have always compressionratio of 0)

2. What is the ratio if i have two or more BLOB in a table?

3. Will the PLSQLDev support this feature?

Greetigs
Sven

 

[Marco Kalter]

1. Is there anything else i have to do on compressing long-field

Only binary fields (BLOB and LONG RAW) can be compressed. Character fields like CLOB and LONG cannot be compressed, because the character data will be transated by Oracle Net.

2. What is the ratio if i have two or more BLOB in a table?

The average ratio.

3. Will the PLSQLDev support this feature?

Yes (in a future release).

------------------
Marco Kalter
Allround Automations

 

[SvenHeuer]

Long Raw?!

I have only one table using a long (ReportBuilder). I should change this......

Thanx