같은 sql의 다른 검색값 속도 채택완료
$cnt_sql_1 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$today' order by no desc"; $cnt_res_1 = mysql_query($cnt_sql_1) or die($cnt_sql_1); $cnt_row_1 = mysql_fetch_array($cnt_res_1);
$cnt_sql_2 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$day_1' order by no desc"; $cnt_res_2 = mysql_query($cnt_sql_2) or die($cnt_sql_2); $cnt_row_2 = mysql_fetch_array($cnt_res_2);
$cnt_sql_3 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$day_2' order by no desc"; $cnt_res_3 = mysql_query($cnt_sql_3) or die($cnt_sql_3); $cnt_row_3 = mysql_fetch_array($cnt_res_3);
$cnt_sql_4 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$day_3' order by no desc"; $cnt_res_4 = mysql_query($cnt_sql_4) or die($cnt_sql_4); $cnt_row_4 = mysql_fetch_array($cnt_res_4);
$cnt_sql_5 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$day_4' order by no desc"; $cnt_res_5 = mysql_query($cnt_sql_5) or die($cnt_sql_5); $cnt_row_5 = mysql_fetch_array($cnt_res_5);
$cnt_sql_6 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$day_5' order by no desc"; $cnt_res_6 = mysql_query($cnt_sql_6) or die($cnt_sql_6); $cnt_row_6 = mysql_fetch_array($cnt_res_6);
$cnt_sql_7 = "select sum(cnt) from TB_google_cnt where domain = '$url' and wdate = '$day_6' order by no desc"; $cnt_res_7 = mysql_query($cnt_sql_7) or die($cnt_sql_7); $cnt_row_7 = mysql_fetch_array($cnt_res_7);
같은 테이블에 날짜별(지난 1~ - 7일) 긁어오는 sql문인데 페이지 로딩이 너무 느려서 그런데 쉽게 할수 있는 방법 없을까요?
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인