Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Perfomance and memory consumption of load JSON

  1. How-to
0
Votes
Undo
  1. Paweł Kasperek
    Paweł Kasperek
  2. PowerBuilder
  3. Tuesday, 8 October 2024 12:10 PM UTC

Hi,

I've got a newbie question about the performance and memory consumption in the below scenarios:

- I've got a large JSON file and I need to load it to PB. Which PB type is the best for performance: structure, datawindow (datastore) or nonvisual object?

- The same question for memory consumption.

Maybe, there exists a documentation about the best practice of using PB object for better performance and low memory consumption ?

Regards

Paweł 

Get Latest Version for workspace
Opensheet() fails with Frame ribbon present
Responses (1)
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Tuesday, 8 October 2024 12:49 PM UTC
  2. PowerBuilder
  3. # 1

More information, pl.

1.  Which version of PB you use, or plan to use.
2.  Size of JSON file and approx. no of rows, if imported in a datawindow.
3.  Is your application 32 bit or 64 bit.
4.  What you plan to do with JSON data.

Processing more than 5000 rows using a datawindow is slower (IMO).  

Happiness Always
BKR Sivaprakash

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 8 October 2024 19:53 PM UTC
Hi BKR;

If the JSON file is of a *simple* nature (ie: just straight rows / columns) then the DataWindow object is your best fried here. :-)

If the JSON is of a *complex* nature, then the only avenue would be to use the JSONParser object class. While you can load the data into it from a TXT file, It is of course slower, more memory consumptive and requires coding on your part.

Regards .. Chris
  1. Helpful 1
Paweł Kasperek
  1. Paweł Kasperek
  2. Wednesday, 9 October 2024 12:19 PM UTC
Thank you for your answer. I checked and DW is a good choice for JSON files smaller than 2-3 MB. I wrote our parse to Nonvisualobject using reflection of class definition class. And it works.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 9 October 2024 14:25 PM UTC
Thank you for that great feedback! :-)
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.