日期:2014-05-17  浏览次数:20398 次

asp.net 执行这样的代码会效率么,求大神解答,谢了
 protected void bindggd()
        {           
            using (SqlConnection conn = new SqlConnection(Conn.CONN_STRING))
            {
                if (Cache["xiaochi"] == null)
                {
                    StringBuilder sb = new StringBuilder("select top 5 KeyId,CategoryId,Title from XF_News where CategoryId=18 and ShenHe=1 order by TuiJian desc,Orders desc,KeyId desc;");

                    sb.Append("select PicPathS,Title,TitleLinkUrl from XF_News where CategoryId=19 and ShenHe=1 order by TuiJian desc,Orders desc,KeyId desc;");

                    sb.Append("select * from win_sdtime;");
                    DataSet ds = SqlHelper.ExecuteDataset(conn, CommandType.Text, sb.ToString());
                    Cache.Insert("xiaochi", ds, null, DateTime.Now.AddMinutes(10), TimeSpan.Zero);

                    rptitemgg.DataSource = ds.Tables[0];
                    rptitemgg.DataBind();

                    rprBanner.DataSource = ds.Tables[1];
                    rprBanner.DataBind();

                    dqtime.InnerText =ds.Tables[2].Rows[0]["stimeOne"].ToString();
                    dqtimem.InnerText =ds.Tables[2].Rows[0["stimeTwo"].ToString();
                    hdtime.InnerText =ds.Tables[2].Rows[0["stimeThree"].ToString();
                    hdtimem.InnerText=ds.Tables[2].Rows[0]["stimeFour"].ToString();

                }
                else
                {
                    DataSet ds = (DataSet)Cache["xiaoch