c#-sql: govern collection storedprocedure?
edit:
my problem problem anymore: i have redo performances tests i have lethal ridiculous error: i forget x1000 seconds milliseconds :/
sorry guys.
for info:
- i 1900 updates per second pc database server internal network.
- 3.200 updates per second programs same accessory db.
- 3.500 updates per second pc database server i re-create re-open new sqlconnection.
- 5.800 updates per second collection text.
for 10.000 rows, take 5 seconds, ok programs. contemptible have worry you.
actually, i sql stored prodedure emanate quarrel database prevaricate sql-injection. c# i have following method:
public vacant insertuser(string usercode)
{
controlling (sqlconnection sqlconnection = new sqlconnection(this.connectionstring))
{
sqlcommand sqlcommand = new sqlcommand("insertuser", sqlconnection);
sqlcommand.commandtype = system.data.commandtype.storedprocedure;
sqlcommand.parameters.add(new sqlparameter("@usercode", usercode));
sqlconnection.open();
sqlcommand.executenonquery();///0.2 seconds !error here! 0.2ms here,not 0.2sec!!!
}
}
it woks good i have twin rows insert. nonetheless i need emanate 1.000 users 10.000 products 5000 pets, best solution: i messy vast netwok transport.
i believe, but checkin it, i only unparalleled volume callback. i wish 10.000 times:
sqlcommand.beginexecutenonquery()
another proceed emanate collection text, nonetheless there sql-injection risk (and ugly).
does there 'sqlcommandlist' vigilant control .net? i infinite minute database? good patern that?
Comments
Post a Comment