Hi There.

We discovered an extremely slow Locate statement in our application.
When using LOCATE FOR and applying a WITH statement for the condition it is better to take a lunchbreak.

for instance;
where Thisform.ID is a formvariable storing the ID of the record to be found

With Thisform
LOCATE FOR IDcolumnname == .ID
Endwith

takes upto 10 seconds while

LOCATE FOR IDcolumnname == Thisform.ID

Takes less then 1 second

Why??
(a SEEK statement does not appear to be affected)

Geert van Snik
Zorgned Automatisering B.V.
Wageningen, The Netherlands