且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在for循环中增加插入查询性能

更新时间:2022-10-27 23:02:44

该评论者得到了我的投票。是的我也可以使用 BULK INSERT 。如果您不想要BULK INSERT,那么构建单个查询&执行一次(检查以下链接)。

使用单个数据将多条记录插入MySQL查询 [ ^ ]

Pls help me in this problem
how can i insert fast in for loop using paramertizered query
<pre lang="c#">
for(int i=0;i<=10000;i++)

{

string qry="insert into demo(id,text,name,age,address)values(@id,@text,@name,@age,@address)";

MySqlParameter idP=new MySqlParameter(@id",0);

MySqlParameter textP=new MySqlParameter(@text,slipno/2012-13/);

MySqlParameter nameP=new MySqlParameter(@name,Ram);

MySqlParameter ageP=new MySqlParameter(@age,33);

MySqlParameter addressP=new MySqlParameter(@address",house no#01,new street,New delhi,India);

MySqlParameter[]p={idP,textP,nameP,ageP,addressP};

MysqlHelper.executenonquery(connecionstring,qry,p);

}

That commenter got my vote. Yes I too go with BULK INSERT. If you don't want BULK INSERT then build single query & execute once(check the below link).
Insert multiple records into MySQL with a single query[^]