How do I parse incoming data from very large json (114000+ data)
How do I parse incoming data from very large json (114000+ data)
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
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