Shulou(Shulou.com)05/31 Report--

This article mainly introduces the example analysis of the efficiency of mongodb data insertion in c # operation, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article.

The data insertion speed of mongodb is one of its bright spots. For the same 10000 pieces of data, the insertion speed is faster than that of Mysql and sqlserver. Of course, this also depends on how users use it. If your code uses 10000 connections for 10000 writes, it is not as fast as other databases that use transactions to commit at one time.

Similarly, mongo also provides a way to insert large amounts of data at one time, because there is no such thing as transactions in mongodb, so in the C# driver, the specific method is to insert multiple documents at once by InsertManyAsync (). The counterpart is InsertOneAsync, which inserts one document at a time

InsertManyAsync () this method takes parameters as long as they implement the type of the IEnumerable interface, so list, such a data type

With the same 10000 inserts, the time of the two methods is very different. As shown in the figure:

Using the method of inserting multiple documents at once, it takes only 1.3s to insert 10000 documents, which is divided into 10000 inserts and takes 19.9seconds. There's a big difference. Similarly, I have previously used mysql to insert 10000 records, which takes more than 4 seconds, so it can be seen that the mongodb insertion speed is not blowing.

The specific code is as follows, paste it:

Using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using MongoDB.Bson;using MongoDB.Driver;using System.Diagnostics;namespace sqltomongo {public class MongoHelp {get {if (null = = _ client) {_ client = new MongoClient ("mongodb://127.0.0.1:27017");} return _ client }} public static IMongoDatabase database {get {_ database = client.GetDatabase ("HotelPersonInfo"); return _ database;} set {_ database = value;}} public static IMongoCollection collection {get {return _ collection;} set {_ collection = value;}} protected static IMongoClient _ client Protected static IMongoDatabase _ database; protected static IMongoCollection _ collection; / / Test efficiency. Compare the two methods with public async static void TestMongo () {/ / Custom object RoomInfo roomdata = new RoomInfo (); List docunemts = new List (); collection = database.GetCollection ("HotelPersonInfo"); Stopwatch sw = new Stopwatch (); sw.Start (); for (int I = 1; I < 10000) TobasonDocument +) {/ / mongo extends the tobasonDocument method to user-defined objects. You can directly check the api manual with var roomdatadocument = new BsonDocument (roomdata.ToBsonDocument ()); docunemts.Add (roomdatadocument);} / / 10000 entries / / at a time, and await collection.InsertManyAsync (docunemts) as long as the type of IEnumerable excuse is implemented; sw.Stop () TimeSpan ts2 = sw.Elapsed; Console.WriteLine ("total is" + ts2.TotalMilliseconds); / / insert 10000 times Stopwatch sw2 = new Stopwatch (); sw2.Start (); for (int I = 1; I < 10000; iTunes +) {var roomdatadocument = new BsonDocument (roomdata.ToBsonDocument ()); await collection.InsertOneAsync (roomdatadocument);} sw2.Stop () TimeSpan ts22 = sw2.Elapsed; Console.WriteLine ("total is" + ts22.TotalMilliseconds); / / await collection.InsertOneAsync (roomdatadocument); / / collection = database.GetCollection ("HotelPersonInfo"); / / collection.InsertOneAsync (roomdatadocument);}

A custom object is used in it:

The code is as follows:

Using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using MongoDB.Bson;namespace sqltomongo {public class RoomInfo {public RoomInfo () {/ / id = "test"; Name = "nafd"; Moblie = "123456"; EMail = "dd@qq.com"; Tel = "010123"; Fax = "0755-001"; IdentityId = "616112323231"; RegisterType = "tid"; CardNo = "cardno"; Sex = "male" Birthday = "1999"; Address = "china beijing"; ZipCode = "519000"; RegisterDate = "2015-03-03"; District2 = "District2"; District3 = "District3"; District4 = "District4";} / / public string id {get; set;} / name / public string Name {get; set } / public string Moblie {get;set;} / email / public string EMail {get;set;} / public string Tel {get;set;} / fax / public string Fax {get;set } / ID card / public string IdentityId {get; set;} / ID-- ID card (only need id ID card information) / public string RegisterType {get; set;} / member card number / public string CardNo {get; set } / gender / public string Sex {get; set;} / birthday / public string Birthday {get; set;} / address / public string Address {get; set;} / zip code / public string ZipCode {get; set } public string District2 {get; set;} public string District3 {get; set;} public string District4 {get; set;} / Registration time / public string RegisterDate {get; set Thank you for reading this article carefully. I hope the article "sample Analysis of data insertion efficiency in mongodb Operation" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.