General information
Title:
Locate for using WITH is extremely slow..Why?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only