Information

Title	ParseFile method of JSON ObjectModelParser has poor performance on 64-bit clients for large files

URL Name	parsefile-method-of-json-objectmodelparser-has-poor-performance-on-64-bit-clients-for-large-files

Article Number	000172237

Environment	Product: OpenEdge Version: 11.7, 12.x OS: Windows

Question/Problem Description

When using the ParseFile method of the JSON ObjectModelParser on 64-bit OpenEdge Windows clients (GUI or PASOE AppServers) for large datafiles the performance is massively longer (4 to 7 minutes vs a few seconds when using a 32-bit OpenEdge client).

Steps to Reproduce

Clarifying Information

The following code reproduces the issue when run against a large JSON file (20+ MB in size).

DEFINE VARIABLE jsonObject        AS Progress.Json.ObjectModel.JsonObject        NO-UNDO. 
DEFINE VARIABLE objectModelParser AS Progress.Json.ObjectModel.ObjectModelParser NO-UNDO. 

ETIME (TRUE).
 
objectModelParser = NEW Progress.Json.ObjectModel.ObjectModelParser(). 
jsonObject        = CAST(objectModelParser:ParseFile("SomeLargeJsonFile.json"),Progress.Json.ObjectModel.JsonObject).

MESSAGE "ETime: " ETIME SKIP  
        "Records: " jsonObject:GetJsonArray('SomeDataValue'):LENGTH
        VIEW-AS ALERT-BOX.

Error Message

Defect Number	OCTA-10810

Enhancement Number

Cause

Resolution

Fixed in OE 11.7.5 and OE 12.1.

Workaround

Notes

Keyword Phrase

Last Modified Date	9/23/2024 4:31 PM

ParseFile method of JSON ObjectModelParser has poor performance on 64-bit clients for large files

Information