Archives of the TeradataForum
Message Posted: Sat, 19 Apr 2008 @ 20:31:25 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|