public override async Task InsertTest() { string connString = "Server=127.0.0.1; User Id=postgres; Database=benchmark; Port=5432; Password=pass.123; SSL Mode=Prefer; Trust Server Certificate=true"; var fakeuserUSers = UserUtility.GetFakeUsers(Times).Select(a => JsonConvert.SerializeObject(a)); using (var conn = new NpgsqlConnection(connString)) { conn.Open(); using (var writer = conn.BeginBinaryImport( "COPY test.users (\"User\") FROM STDIN (FORMAT BINARY)") ) { foreach (var user in fakeuserUSers) { writer.StartRow(); writer.Write(user, NpgsqlDbType.Json); } writer.Complete(); } } }
public override async Task InsertTest() { var client = new MongoClient(); var db = client.GetDatabase("benchmark"); var collection = db.GetCollection <User>("users"); var fakesUsers = UserUtility.GetFakeUsers(Times); await collection.InsertManyAsync(fakesUsers); }
public override async Task InsertTest() { var connectionString = "http://localhost:5984/"; var client = new CouchClient(connectionString); var db = await client.GetDatabaseAsync("benchmark"); var fakesUsers = UserUtility.GetFakeUsers(Times); foreach (var userList in UserUtility.SpiltBySize(fakesUsers, 10000)) { await db.BulkInsertAsync(userList.ToArray()); } }
public override async Task InsertTest() { var store = new DocumentStore { Urls = new string[] { "http://localhost:8080" }, }; store.Initialize(); var fakeuserUSers = UserUtility.GetFakeUsers(Times); using (BulkInsertOperation bulkInsert = store.BulkInsert("benchmark")) { foreach (var user in fakeuserUSers) { bulkInsert.Store(user); } } }
public override async Task InsertTest() { ArangoDatabase.ChangeSetting(s => { s.Database = "benchmark"; s.Url = "http://localhost:8529"; // you can set other settings if you need s.Credential = new NetworkCredential("root", "pass.123"); s.SystemDatabaseCredential = new NetworkCredential("root", "pass.123"); }); var fakesUsers = UserUtility.GetFakeUsers(Times); using (var db = ArangoDatabase.CreateWithSetting()) { foreach (var userList in UserUtility.SpiltBySize(fakesUsers, 10000)) { db.Collection("Users").InsertMultiple(userList); } } }
public override async Task InsertTest() { var cluster = Cluster.Builder() .AddContactPoints("127.0.0.1") .WithPort(9042) .Build(); var session = cluster.Connect("benchmark"); var userttemplate = session.Prepare("INSERT INTO users (userid, name, birthday, currentsalary) VALUES (?, ?, ?, ?)"); foreach (var userList in UserUtility.SpiltBySize(UserUtility.GetFakeUsers(Times), 100)) { var batch = new BatchStatement(); foreach (var _user in userList) { batch.Add(userttemplate.Bind(_user.UserId, _user.Name, _user.Birthday, _user.CurrentSalary)); } session.Execute(batch); } }