Hi,
I am retrieving data from My SQL data base but it is slow adding parameters please guide me how i can make it fast
Thanks in advance,
My code is this foreach is making it slow please guide how can i make it fast.
public static DataTable SelectStoredProcedure(string name, params MySqlParameter[] parameters)
{
DataTable data = new DataTable();
MySqlCommand cmd = new MySqlCommand(name, new MySqlConnection(connectinonString));
cmd.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
foreach (MySqlParameter param in parameters)
{
cmd.Parameters.Add(param);
}
}
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
adapter.Fill(data);
return data;
}
...
Go to the complete details ...