Hi,
I'm have a performance issue with VFP6 using DBC and tables. I have run the coverage profiler and have discovered that one line in the code is taking over half of the total time.

UPDATE Iciwhs set ninprocess = ninprocess + lnInProcess where citemno = lcItemno and cWarehouse = lcWarehouse


I read the help and discovered the info on performance issues using update. The help suggested that FLOCK be used but I quickly discovered that using FLOCK made UPDATE run faster but getting the FLOCK took almost the same amount of time. I then tried REPLACe without FLOCK and had a minor speed improvement.

So does anyone have any suggestions?

TIA
John