How can I use large .json files?

Discuss
, ,
#1

What would be the most logical way to use a 25Mb .json data store quickly and stably?

When I want to display the data in a list or other form, it takes quite a while to process the data. I need ideas from the kodular community so I can minimize this wait time.

#2

No body knows whether this will work or not. Do you how long will it take place to parse? Reconsider your idea

#3

It takes about 40-50 seconds with the Huawei P20 Pro. There’s an annoying waiting time when the search process has multiple or incorrect entries.

Actually, I think starting the search process after the user enters 5 letters in the text box can solve this problem, but I could not try this method because there is no block to change the Search text in the list view block options. Can you help with this?

#4

Better use any online database . I am not sure how for you will get result. We have tested with 13k rows from gsheet and we search for an item from this rows in just 5sec… if you use online dB may be you can reduce you problem…

1 Like
#5

The most logical way would be not to use such a large json file. Use a sqlite file or online database where you can select your data.

Why would you think that?

1 Like
#6

I extracted the data I will list from .json and made a list in a separate place. Now the waiting time is gone but do I need to extract all the data like this?

To explain better, I want to show you an example from the .json list.

{
	"RECS": [
			{
            "id": "1",
            "u_hash": "",
            "b_id": "",
            "name": "Test Name 123",
            "pic": "",
            "rel_at": "",
            "cor_XY": "",
            "back": "",
            "st": "",
            "dis_size": "",
            "dis_res": "",
            "pix": "",
            "v_pix": "",
            "set": "",
            "now": "",
            "Real": "",
            "type": "",
            "speck": "",
            "del_at": "",
            "add_at": "",
            "up_at": ""
			  }
			]
}
#7

You nust post only in English… MIT community only will accept all language else your topic will be delisted or flagged

#8

I solved the problem. I think my need some java knowledge.
I solved this problem with the following Kio4 extension and java related documentation.

Kio4 DecoJson;
Uygulama Sorumlusu. Uzantı. Json’ın kodunu çözün. JsonPath. Json’dan Xml’e ve Xml’den Json’a dönüştürün. (kio4.com)

Documents;
McKeeman Formu (crockford.com)
Çeşitli Örnekler | JSON Şeması (json-schema.org)
json-path/JsonPath: Java JsonPath uygulaması (github.com)

I write all the articles using google translate and sometimes I forget to edit. So it’s not something I did intentionally.

My project is not registering. It's constantly rollback - #18 by TheSky