[Stackoverflow] [Progress OpenEdge ABL] Can a table which has larger record gets often hitting in for each loop cause performance issue? - PROGRESS 4G

[David]

I have a below simple query which causes a performance issue. a table xxdata has huge records and it's getting often hits based on total records available in table xxfin.(i.e Available records 1000 in table xxfin, then 1000 times hits table xxdata).

This is causing performance issue. As checked XREF of this query, compiler shows correct indexes for both table.

FOR EACH xxfin NO-LOCK WHERE xxfin.setValue = 9:
**Some additional logic goes here but this is not causing any issues, Since I have commented them and checked**
    FOR EACH xxdata NO-LOCK 
       WHERE xxdata.linkno = xxfin.setValue
       AND xxdata.duo = "FINISHED":
    END. /*FOR EACH xxdata*/
END. /*FOR EACH xxfin */

Continue reading...