I don't know if the following method really is better, but it's worth
a try, because from old school I would rather not create and destroy
too many objects unnecessarily.
Dbcmd = Dbconn.CreateCommand();
Dbcmd.Transaction = Dbtrans;
Dbcmd.Connection = Dbconn;
Dbcmd.CommandType = CommandType.Text;
Dbcmd.CommandText = "INSERT INTO TEST(IDCODIGO,TESTE) VALUES
(@IDCodigo, @Teste)";
Dbcmd.Parameters.Add("@IDCodigo", FbDbType.VarChar, 6);
Dbcmd.Parameters.Add("@Teste", FbDbType.VarChar, 6);
for (int i = 0; i < 500000; i++)
{
Dbcmd.Parameters[0].Value = i.ToString();
Dbcmd.Parameters[1].Value = i.ToString();
Dbcmd.ExecuteNonQuery();
}
ciao,
André
------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
