i have a sql query in my asp.net project where i take union of multiple queries..wen i use single query i get result in time but by using multiple queries the time taken is too much..pls look at the code n suggest..
conn1.Open();
conn2.Open();
double z = 0;
string sql = "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth>=" + twelveth + " and Diploma>=" + diploma + " and Graduation>=" + graduation + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no ;"
+ " UNION " + "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth=" + 0 + " and Diploma=" + 0 + " and Graduation>=" + graduation + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no;"
+ " UNION " + "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth>=" + twelveth + " and Diploma=" + 0 + " and Graduation=" + 0 + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no;"
+ " UNION " + "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth=" + 0 + " and Diploma>=" + diploma + " and Graduation=" + 0 + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no;"
+" UNION " + "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth>=" + twelveth + " and Diploma>=" + diploma + " and Graduation=" + 0 + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no;"
+ " UNION " + "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth>=" + twelveth + " and Diploma=" + 0 + " and Graduation>=" + graduation + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no;"
+ " UNION " + "select `btechstudent_academics`.Regd_no,Sname,DOB,Batch,Email,Phone,Stream,Branch,Tenth,Twelveth,Diploma,Graduation,Btech,Backlog,Yeargap,Skills from `btechstudent_academics`,`btechstudent_details` where Tenth>=" + tenth + " and Twelveth=" + 0 + " and Diploma>=" + diploma + " and Graduation>=" + graduation + " and Btech>=" + btech + " and Backlog<=" + backlog + " and Yeargap<=" + yeargap + " and Stream='" + stream + "' and `btechstudent_academics`.Regd_no=`btechstudent_details`.Regd_no;";
MySqlCommand com = new MySqlCommand(sql, conn1);
MySqlDataAdapter da = new MySqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
Show.DataSource = ds;
Show.DataBind();