Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Jul 2003 @ 16:17:34 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: OLTP Application Design Considerations
From:   Pradeep Patil

Hi LeBlanc,

We insert and update 3000 + rows in 4-5 tables after manipulating data. For data consistency we make auto commit false and this executes in one transaction . There are some places in application when updating table primary index is not handy. Even due to business requirement cant define unique primary index. In special cases duplicate primary indexes are more than 100.

We use 2 node machine and its testing environment.

Yes thats true success for application will depend 60% on design thats why I told him some points to consider while he start design.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023