For some reason when I use parameters in my sql query in C# it is way slower than when I do it in SSMS, it is so slow in C# that it times out. It becomes slow when I use my parameters.
string occurencesQuery = @"SELECT Date, Organization, [User], Browser, ClientVersion, ServerVersion, Server FROM cloud.ErrorLog
WHERE Date BETWEEN @day AND @endDay AND
Message_index LIKE @message
ORDER BY Date DESC OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY";
using (SqlCommand cmd = new SqlCommand(occurencesQuery, conn))
{
conn.Open();
cmd.Parameters.Add("@message", SqlDbType.VarChar, 200).Value = message;
cmd.Parameters.Add("@day", SqlDbType.DateTime).Value = day;
cmd.Parameters.Add("@endDay", SqlDbType.DateTime).Value = endDay;
Aucun commentaire:
Enregistrer un commentaire