Well i did a test using exp with compress running in background using pipes..
the table had 6million records and was 3G big..
export (exp) + compression (using pipe) took 4.5 mins
export (exp) + cpmpression (serial task) took 6.0 mins
hardly 1.5 mins difference and that compression took about 2 mins of this total time..
PS, I should admit that i missed the gist of pipe.. your actalluy right..
i had said before
indeed this is the case, from above test.. the time difference seen is solely because the process is a serial one and former is virtual parallelism..Quote:
i meant LIO + CPU Time for compression is nearly equal to time required for PIO to local file system..
if we have the table of 20G, then there will still be a max difference of 5-10 mins (required for compression)
I mentioned in my other post that point 2 was not very significant.. as was point 3.. and indeed it is.. your point 2 would be significant if it were a table to 100-200G.. i really suspect if that is the case..
