I am curious to know how much of your delay is due to PostgreSQL
and how much to your Java batch program. If you comment out the call to
the database function, so that you are reading your input file but not doing
anything with the data, how long does your batch program take to run? RobR -- The Java program hardly takes a minute to process all the flat
files but at the time inserting the records into the db, the entire process
takes more than 4 hours. Many thanks |