Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 02 Feb 2007 @ 12:41:01 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: How Do You Measure/Validate Compression Savings?
 
From:   Victor Sokovin

  - Re "saving nodes": Saving nodes cannot be calculated only on space. Both space and compute/IO resources must be considered. MVC's space savings is not in the same proportion as the resource savings. Thus, purely for example your mileage will vary, if you save 30% of space you may well only save 5% of CPU/IO for a particular workload. Thus the number of nodes saved would only be 5% if holding response time/throughput constant was the goal.  


I was not following this thread so only catching up.

I think MVC might actually lead to the *increase* in, say, CPU usage if MVC is liberally applied to "small" tables on a large scale. If there is compressing then there must be uncompressing going on somewhere down the line, no? It is hard to measure all the effects without access to a good test lab, though.

The idea of having a tool for MVC never occurred to me before I read the thread, probably because of the fear of compressing "small" tables and causing weird adverse effects elsewhere.


Regards,

Victor



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020