果糖网

Can you be specific or have relevant docments

```cs //Sql INSERT INTO "users" ("sid","createtime","username","password") VALUES(@Sid0,@createtime1,@username2,@password3), (@Sid4,@createtime5,@username6,@password7), (@Sid8,@createtime9,@username10,@password11), (@Sid12,@createtime13,@username14,@password15), (@Sid16,@createtime17,@username18,@password19), (@Sid20,@createtime21,@username22,@password23), (@Sid24,@createtime25,@username26,@password27), (@Sid28,@createtime29,@username30,@password31), (@Sid32,@createtime33,@username34,@password35), (@Sid36,@createtime37,@username38,@password39) //c# NpgsqlCommand sqlCommand = new NpgsqlCommand(sql, (NpgsqlConnection)this.Connection); `` So far, it's only a million...

I tried to use PGSQL bulkCopy, but failed. I do not know whether it is supported.

> You can try `Prepare()` > > https://www.npgsql.org/doc/prepare.html#simple-preparation > > https://stackoverflow.com/questions/54691579/preparing-statements-and-batching-in-npgsql Your code is slower, much slower than my paging batch

``` Npgsql.NpgsqlCommand com = new Npgsql.NpgsqlCommand(x.Key, (Npgsql.NpgsqlConnection)db.Ado.Connection); foreach (var item in x.Value) { com.Parameters.Add(new Npgsql.NpgsqlParameter(item.ParameterName, item.Value)); } com.Prepare(); foreach (var item in list) { foreach (var v in db.Insertable(item).ToSql().Value) {...

> Pg interface is not the fastest in QuestDB and will never be because of protocol overhead. What are you archiving in terms of inserts per seconds on what table...

This results in PGSQL reaching 6 seconds per million, while QuestDb is only 20

I hope you can support that ```cs using (var writer = conn.BeginBinaryImport(copyString)) { foreach (DataRow row in dt.Rows) { writer.StartRow(); foreach (var column in columnViews) { var value = row[column.DataColumn.ColumnName];...

This has nothing to do with PGSQL, but mainly because of the table deletion operation on your web console

1. Control the Web console to delete tables 2. Start the C# program