[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: can-find: resolved where?

  • Thread starter Thread starter Francisco Morales López
  • Start date Start date
Status
Not open for further replies.
F

Francisco Morales López

Guest
Hello, it is important to remember the purpose of this function. Mainly you will use it to validate the existence of records that meet a condition, generally validate duplicates in advance. It is faster because it does not update blocking flags and does not bring the entire record to memory. Regarding the response time, any search that is not associated with values in index will become a slow search whole-index This regardless of whether it is a physical search or a logic such as can-find. In case this need arises it is important that you verify the same design of the database, because you are forcing the database manager to validate something for which it is not prepared

Continue reading...
 
Status
Not open for further replies.
Back
Top