[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Transactions during READ-JSON for NO-UNDO temp-table.

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
I wrapped the READ-JSON() with an explicit transaction and it changed the behavior slightly. The difference is that now the 4GLTRANS output says "BEGIN SUB-TRANS" and "END SUB-TRANS" for all these records. The performance improvement is not that great (5 to 10 %). Ideally there would be a version of READ-JSON() that worked the same way as creating the TT records from ABL statements. Please let me know if anyone has a way to avoid the performance overhead of transactions during READ-JSON(). I haven't specifically tested but I don't think an "IMPORT" statement for the same TT would have this overhead. Here is the KB: knowledgebase.progress.com/.../P4129

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