Program performance incease ideas

Hi All,

 

I have a portion of one of my programs that does this:

 

Read Myfile

Do while not eof(Myfile)

  Read Myfile

  SQLSum = Get the sum of a series of records where somepart = current part# 
and somecolour = current part colour

  NewSum = CurrentSum - SQLSum

  Update Myfile

  Read Myfile

EndDo

 

I find this process to be very time-consuming, as each SQL transaction takes 
about 2-7 seconds to complete.  I'm using a logical file to get the data that 
is keyed on the part number and colour as well as only selecting records that 
have a status of 3 or 5.

 

Any ideas on how I could speed this up?  The physical file which it is updating 
only has 1400 records in it, and it's been running now for the past ½ hour and 
has less than ½ the records processed.

 

Thanks,

 

Brian. 

 

-=-=-=-=-=-=-=-=-=-=-=-=-=-

Brian Piotrowski

Specialist - I.T.

Simcoe Parts Service, Inc.

Ph: 705-435-7814 x343

Fx: 705-435-6746

bpiotrowski@xxxxxxxxxxxxxxx

-=-=-=-=-=-=-=-=-=-=-=-=-=-