Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 05 Nov 2002 @ 14:11:08 GMT


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


Subj:   Fallback Performance Degradation
 
From:   Eva Mitter

We are inserting about 400,000 rows into an empty table with fallback option and that takes about 8 seconds. The second insert of another 400,000 rows used to take about 25 seconds. Recently this second insert is taking about 5.5 minutes. After more research we noticed that the performance degradation is happening on all tables that were setup with fallback.

We noticed the performance problems over the period of two weeks. During that period we didn't install/updated any software on the system, our DBA didn't do any performance tuning, there were no hardware changes. The only change was that the size of our database increased by about 30%; at this point we are still using less that 10% of the overall system capacity.

Where should we look to resolve this issue?


Thanks in advance,

-eva



     
  <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: 27 Dec 2016