How should I implement massive insert in OrientDB I have 10K Vertex have almost 1M Edges how should i Load as fast as possible? Currently i am using this for loop and it takes more than 30 mins to complete.
Please suggest some feasible solution.
List _listRating = LoadRatings(_PathRatings);
foreach (Rating r in _listRating)
{
i++;
oDB.Command(" create edge rated from (select from Users where userID = " + r.userID + ") to (select from Movies where MovieID = " + r.movieID + " ) set rating =" + r.Ratings + " ");
Console.WriteLine("Creating Ratings...." + i.ToString());
}
How should I implement massive insert in OrientDB I have 10K Vertex have almost 1M Edges how should i Load as fast as possible? Currently i am using this for loop and it takes more than 30 mins to complete. Please suggest some feasible solution.
List _listRating = LoadRatings(_PathRatings);
foreach (Rating r in _listRating)
{
i++;
oDB.Command(" create edge rated from (select from Users where userID = " + r.userID + ") to (select from Movies where MovieID = " + r.movieID + " ) set rating =" + r.Ratings + " ");
Console.WriteLine("Creating Ratings...." + i.ToString());
}