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

The datatables json part comes from here

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('');
$json_data = json_decode($json2,true);
foreach($json_data["data"] as $v){

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


This question has an accepted answers - jump to answer


  • colincolin Posts: 15,095Questions: 1Answers: 2,581
    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,



Sign In or Register to comment.