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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members