[progress Communities] [progress Openedge Abl] Forum Post: Re: What's The Use Of The Assign...

[Tim Kuehn]

[quote user="Laura Stern"] There has been a long-standing belief that using ASSIGN improves performance. I thought that was debunked, but I just tried this little experiment (on Windows) and it is consistently faster with the ASSIGN with or without NO-UNDO. [/quote] As I recall from the docs, ASSIGN does all the assigns as a single instruction, while individual "=" do them separately - hence the slight bump in performance. The rare times you'd want break up an ASSIGN is to when some of the fields are part of an index and you need to ensure that an index constraint isn't violated.

Continue reading...