search

maxsatula / ocp

Oracle Copy utility
GNU General Public License v2.0
13 stars 2 forks source link

On-the-fly compression #7

Closed maxsatula closed 10 years ago

maxsatula commented 10 years ago

Reduce network traffic by compression and immediate decompression on the other side. For example, if uploading a local file to Oracle

  1. Compress a local file in memory, and take compressed raw data piece by piece into buffer.
  2. Pass the buffer contents with compressed piece to PL/SQL as a bind variable.
  3. PL/SQL code, before using UTL_FILE, makes calculations on the buffer to get decompressed data, then passes to UTL_FILE
maxsatula commented 10 years ago

Packages/libraries suggested http://www.gzip.org/zlib/manual.html - local site UTL_COMPRESSION - remote site