Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Mar 2003 @ 16:22:26 GMT


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


Subj:   Multiple updates to one table by several users
 
From:   McCann, Andy

All,

If several users want to update the same table at the same time, what is the best strategy to minimize contention? The tables are metadata, users access the tables via 1-1 views with locking for access and do single row updates. If the same Teradata user is used by all users of the system, will this makes matters better or worse?

This is one of those situation where I think I know what the answer is but need some verification. Also, if anyone has any metadata tables they use in this way and have developed a good strategy, any ideas would be useful.


Cheers

Andy



     
  <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