Databases
StackOverflow2013
Postsdbo
POC#-SQL: How to execute a batch of StoredProcedure?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POC#-SQL: How to execute a batch of StoredProcedure?
    primarykey
    data
    text
    <p><em>Edit: <br>My problem is not a problem anymore: I have redo my performances tests and I have do a fatal stupid error: I had forget a x1000 to get seconds from milliseconds :/ Sorry for that guys.<br> For info: <br> - I do some 1900 updates per second from my PC to the DataBase server on local network.<br> - 3.200 updates per second if the programs is on same machine than DB.<br> - 3.500 updates per second from my PC on the DataBase server I do not re-create and re-open a new SQLConnection.<br> - 5.800 updates per second with a batch text. For my 10.000 rows, if it take 5 seconds, it is ok for my programs. Sorry to have worry you.</em></p> <p>Actually, I use a SQL stored prodedure to create a row in my database to avoid SQL-injection. In C# I have the following method:</p> <pre><code>public void InsertUser(string userCode) { using (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!!! } } </code></pre> <p>It woks great when i have one or two rows to insert. But if i need to create 1.000 users and 10.000 products and 5000 pets, it is not the best solution: I will loose a huge time in netwok transport.</p> <p>I believe, without checkin it, that I can use just a limited amount of callback. So I do not want to call 10.000 times: </p> <pre><code>sqlCommand.BeginExecuteNonQuery() </code></pre> <p>Another way will be to create a batch text, but there is a SQL-Injection risk (and it is ugly).</p> <p>Does there is a 'SqlCommandList' object that manage that in .Net? How do I do large writing in database? What the good patern for that?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOlivier de Rivoyre
    1. USOlivier de Rivoyre
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POC#-SQL: How to execute a batch of StoredProcedure?
      1. USstahler
      1. VTFavorite
    2. VO
      singulars
      1. POC#-SQL: How to execute a batch of StoredProcedure?
      1. USMark Brackett
      1. VTFavorite
    3. VO
      singulars
      1. POC#-SQL: How to execute a batch of StoredProcedure?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI would recommend to use "sqlCommand.Prepare();" with parameter type which should improve the execution time on second query at least.
      singulars
      1. POC#-SQL: How to execute a batch of StoredProcedure?
      1. USJ Pollack
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload