oracle - Taking too long to insert records in Elasticsearch in c# -
the following code pulls data 2 tables table1 , table2, performs join on them, on field 3 , indexes elasticsearch. total number or rows need indexing around 500 million. code inserts 5 million records in 1 hour, way take 100 hours complete. there way can make faster? public static void selection() { uri node = new uri("http://localhost:9200"); connectionsettings settings = new connectionsettings(node); elasticclient client = new elasticclient(settings); int batchsize = 100; string query = "select table1.field1, table2.field2 table1 join table2 on table1.field3=table2.field3"; try { oraclecommand command = new oraclecommand(query, con); oracledatareader reader = command.executereader(); list<record> l = new list<record>(batchsize); string[] str = new string[2]; int curr...