Quote Originally Posted by PAVB
I'm in agreement with your assesment of increased CPU utilization for compress/uncompress purposes.

In regards to LIO -respectfully- I don't care about it, I care about physical I/O. Remember, we are doing exp/compress and uncompress/imp on-the-fly therefore in the first case exp is writting to an Unix pipe then compress reads from the Unix pipe and writes to disk; in the second case uncompress reads from the compressed file and writes to an Unix pipe from where imp reads.
I dont think you got the GIST.. i meant LIO + CPU Time for compression is nearly equal to time required for PIO to local file system.. all it matters is how much data your moving over network, that time vs data over netwrok is exponential.

however you should also note that OS will be making lots of LIO+PIO while doing a compression/uncompression (plus a added over head of CPU due to extensive LIO + processing the compressing algorithm).. the point 2 of yours hardly matters.. all it matters is point 3, which is obivious and evident.

Rgds
Abhay.