Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 19 Apr 2008 @ 20:31:25 GMT

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

Subj:   Re: Real Time Load
From:   Joseph D silva


Some of the things you would want to check is what is the kind of locking thats happening against these tables...

Are they using rowhash level write locks (Table level write locks can be a real pain in these scenarios)... Do they use access locks for reading ? Have you noticed any deadlocks happening in the system ?

Also you would want to explore the batcharray/Fastload features of JDBC which gives higher performance, if that's possible in your case...


Joseph D'silva

  <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