Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Jun 2001 @ 13:48:06 GMT


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


Subj:   Re: Access Logging Question
 
From:   Jon Musselwhite

I can not remember if this has been mentioned for this thread - but if you are using the ODBC to connect (via SAS, or MS Access, etc) - ODBC tends to turn "bulk" requests into insert selects, one per row. Try and use "pass through" SQL where appropriate.

If this is unavoidable, and there is enough space on your system, copy the days log entries to another database, and then delete those entries from the DBC. This will, at least, improve the dictionary performance. Plus allow any analysis against the table to be performed away from the dictionary. From here you can opt to improve the index on the access log history table created.


Hope this helps,

Jon.



     
  <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