FIND FIRST vs. FOR FIRST Performance

[kryer]

Could Progress add a toggle to the client startup to make a FIND FIRST perform as well as a FOR FIRST statement. the best practices on the SQL Dataserver group suggest rewriting FIND FIRST Statements to be FOR FIRST statements to take advantage of a different query engine. This is a very large undertaking in a system of significant size and it also makes the code look less elegant . FIND FIRST customer WHERE customer.CustomerCode = "101" NO-LOCK NO-ERROR. VS. FOR FIRST customer WHERE customer.CustomerCode = "101" NO-LOCK: LEAVE. END.

Continue reading...