Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2001 @ 06:25:40 GMT

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

Subj:   Re: WinCLI vs. ODBC
From:   Eric Kohut


There is a probably a very explanation of why it took so long to load the data using JDBC. While the utilities is usually the best answer because they are designed to handle large amounts of data in a batch mode in the simplest and least time consuming to develop, there are usually ways (if desired) to make user applications run nearly as fast and given the correct utility to compare to, nearly as efficiently as well.

There a many ways to optimize the loading of data from a user application. The highlights have been mentioned many times on this forum.

If you are loading historically stored data, then a batch utility is almost always the best approach, but there are other alternatives if you are interested and will invest the time to learn the proper tuning techniques.

Good Luck,


Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

  <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