Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Add Connection Parameter Compress BLOB for Interbase?



Permlink Replies: 2 - Last Post: Dec 1, 2017 7:17 PM Last Post By: wesley bobato Threads: [ Previous | Next ]
wesley bobato

Posts: 19
Registered: 3/17/10
Add Connection Parameter Compress BLOB for Interbase?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 1, 2017 7:02 PM
Hello Team.

I've been trying to migrate my project from IBDAC to FIREDAC
I found a problem.

Does Firedac have no data compression for fields in the BLOB-type interbase?

In IBDAC has a parameter used in the Query that allows to compress the BLOB and the size in the database is small but I can not do this with FIREDAC.

here is documentation from ibdac

https://www.devart.com/ibdac/docs/?work_blob.htm
https://www.devart.com/ibdac/docs/index.html?devart.dac.tdadatasetoptions.compressblobmode.htm
https://www.devart.com/ibdac/docs/index.html?devart.dac.tcompressblobmode.htm

Is there a connection parameter?

FDConnection1.Params[ 'blob_compress' ] := True; ??

Do I need to develop a demo? disassembling the column size difference to demonstrate that the compression works?

Thank you.
wesley bobato

Posts: 19
Registered: 3/17/10
Re: Add Connection Parameter Compress BLOB for Interbase?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 1, 2017 7:14 PM   in response to: wesley bobato in response to: wesley bobato
wesley bobato

Posts: 19
Registered: 3/17/10
Re: Add Connection Parameter Compress BLOB for Interbase?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 1, 2017 7:14 PM   in response to: wesley bobato in response to: wesley bobato
Understanding Shows a 66% improvement in disk size.

I have a table with 15MB without Compression and with Compression it had a reduction to 4.5 MB

Edited by: wesley bobato on Dec 1, 2017 7:17 PM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02