mardi 21 juin 2016

sql query timeout when using parameters in C#

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