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