[progress Communities] [progress Openedge Abl] Forum Post: Odd Performance Question

  • Thread starter Thread starter Jeff Ledbetter
  • Start date Start date
Status
Not open for further replies.
J

Jeff Ledbetter

Guest
Hi. We have a table with 4 key fields and a RAW field (16k max size). We need to blast through all of those records and update one of the key fields. Ok, that's simple. I'll just do a FOR..EACH. What I am surprised by is the performance. There are only 300 records in the table but it takes at least 11-12 seconds to update them all. If there is no update, it's only a matter of milliseconds to read them. With a RAW field in the table, is there some extra overhead for for an update (even though the RAW field itself is not getting updated)? Thanks.

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