Why does this run in about 7 seconds for a the first few times I run it and then get increasingly slower after that?
using (SqlConnection con = new SqlConnection(connectionStr))
{
con.Open();
using (SqlCommand sql = new SqlCommand("selectcombos"))
{
var returnParameter = sql.Parameters.Add("@val", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
sql.Parameters.AddWithValue("@Id", ID);
var timer = new Stopwatch();
timer.Start();
sql.CommandType = CommandType.StoredProcedure;
sql.Connection = con;
for (int i = 0; i < 50000; i++)
{
sql.ExecuteScalar();
var res = returnParameter.Value;
}
timer.Stop();
TimeSpan timeTaken = timer.Elapsed;
string time = "Time taken: " + timeTaken.ToString(@"m\:ss\.fff");
MessageBox.Show(time);
}
}
It is a large database table with about 100 million rows.