How do I parse incoming data from very large json (114000+ data)

How do I parse incoming data from very large json (114000+ data)

KonyaKonya Posts: 5Questions: 3Answers: 0

I made the data in mysql databases come quickly using datatables I need to parse this data, it is very heavy when I do it with mysql

data at this link
https://www.kupondas.xyz/oran/

The datatables json part comes from here

https://www.kupondas.xyz/oran/scripts/ids-objects.php

Unfortunately, the link does not even open because it is too big

how can i parse it between all data in the fastest way?

there is a total of 114,000 + data

How do I do a filtering like this in php, as in the example images and codes?

The code below unfortunately did not work

$json2 = file_get_contents('https://www.kupondas.xyz/oran/scripts/ids-objects.php');
$json_data = json_decode($json2,true);
foreach($json_data["data"] as $v){

    if($v["lig"]=="GUR" and $v["ms1"]=="3.00"){
        echo "<pre>";
        print_r($v);    

    }
}

This question has an accepted answers - jump to answer

Answers

  • colincolin Posts: 15,112Questions: 1Answers: 2,583
    Answer ✓

    You would need to server-side processing for that volume of data. For server-side processing, enable serverSide. The protocol is discussed here. Also see examples here. If you download the DataTables repo, there are examples of the server-side scripts in /examples/server_side/scripts,

    Cheers,

    Colin

Sign In or Register to comment.