Hi
I have a data base have 57 M data in mysql when i transfer data via this code (php)
$search_host = '127.0.0.1';
$search_port = '9200';
$index = 'myindex1';
$doc_type = 'tweecoms1';
//hada reste static f 1M
$combien=1000000;
$limit=$_GET['l'];
$re = "select * from tweecoms as Tweecom limit $limit,$combien";
$r=$Acc->Select($re);
while($k=$r->fetch()) {
$i++;
$json_doc = array(
"association_key" => $k['id'],
"text" => $k['text'],
"photo" => $k['photo'],
"lien" => $k['lien'],
"date" => $k['date'],
"source" => $k['source'],
"id_tweecom" => $k['id_tweecom'],
"nb_retweets" => $k['nb_retweets'],
"nb_favorite" => $k['nb_favorite'],
"nb_followers" => $k['nb_followers'],
"hashtag" => $k['hashtag'],
"origine" => $k['origine'],
"acceleration" => $k['acceleration'],
"influence" => $k['influence'],
"sentiment" => $k['sentiment'],
"user_id" => $k['user_id'],
"post_id" => $k['post_id'],
$id = $k['id'],
);
$text = json_encode($json_doc);
$baseUri = 'http://' . $search_host . ':' . $search_port . '/' . $index . '/' . $doc_type . '/' . $id;
$ci = curl_init();
curl_setopt($ci, CURLOPT_URL, $baseUri);
curl_setopt($ci, CURLOPT_PORT, $search_port);
curl_setopt($ci, CURLOPT_TIMEOUT, 200);
curl_setopt($ci, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ci, CURLOPT_FORBID_REUSE, 0);
curl_setopt($ci, CURLOPT_CUSTOMREQUEST, 'PUT');
curl_setopt($ci, CURLOPT_POSTFIELDS, $text);
$response = curl_exec($ci);
curl_close($ci);
}
echo "\n \r j'ai fini sa ".$_GET['l'];
i have just 45 225 890 data look image clic to see image
how i can put all of my data in elastic and what's this docs: 45 225 890 (55 568 524) i have in my elastic 45 225 890 data or 55 568 524 data
English is not my native language, sorry for any mistakes.