Home -> Mailing Lists -> Oracle-L -> Re: Effective compression ratio with minimal performance overhead

Re: Effective compression ratio with minimal performance overhead

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 22 May 2022 16:23:30 -0400
Message-ID: <512d6495-1e0e-ff3c-9a18-919cd0ee5e86_at_gmail.com> 





  
    
  
  
    
On 5/22/22 15:31, Lok P wrote:

    

    
With
      Advanced compression, a table of size ~500GB is reduced to ~100GB.
      But the execution time of a batch INSERT query (using a batch size
      of 100) is increased from ~6minutes to ~13minutes for 10million
      rows. And run time of a multi threaded 'UPDATE' using pipelined
      function has been increased from ~11minutes to ~29minutes. It was
      updating 16million rows.

    
Well, there is no such thing as a free lunch. And thee is no such
      thing as cheap gasoline. 

    

    
-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com


  

--
http://www.freelists.org/webpage/oracle-l
Received on Sun May 22 2022 - 22:23:30 CEST












Original text of this message