Feb 10, 2015 03:11 AM|vishnuskp|LINK
I have a asp.net web application. It contain more than 40000 records. I want to search the records according to the description. The description will be two sentences. The database is in sql. How can I increase the search speed.
Here is my code.
String str = "select * from MyMast where (DESCRIP like '%' + @search3 +'%')";
SqlCommand xp = new SqlCommand(str, con);
xp.Parameters.Add("@search3", SqlDbType.VarChar).Value = TextBox4.Text;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = xp;
DataSet ds = new DataSet();
GridView1.DataSource = ds;