Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Apr 2016 @ 20:56:00 GMT


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


Subj:   Multiple session inserts to the same table
 
From:   Bakthavachalam, Roopalini

Forum -

We are on TD 15. One of the tables in our application is accessed by multiple users at the same time. However up until now, the inserts were very fast and we never noticed the blocking, however now after enhancing the application for more features, the inserts are taking longer and it is causing contention. My question is without re-architecture, is there any way we can avoid this?

The exact issue is - The application runs for different scenarios and inserts the records in one final table. So I need to figure out a way to avoid the blocking when multiple users are running scenarios and inserting records to that same final table. I was thinking in terms of creating the final table as GTT, however I need to get the records for all the scenarios run by users (from different sessions) to the final table in order to do further processing, which cannot be achieved if I use a GTT table.

I also thought of creating the table a NoPI so that the inserts are faster. Are there any other ways here?

Any ideas here will be a big help.


Thanks

Roopalini



     
  <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