[제나플러스] 그누보드 튜닝 (최근글) > 팁앤테크

/lib/latest.lib.php

(참조 - CCC님)
http://www.sir.co.kr/bbs/board.php?bo_table=g4_tiptech&wr_id=13944

★ $board의 불필요한 조회를 줄인다

// 원본 (수십개의 field를 select)
//$sql = " select * from $g4[board_table] where bo_table = '$row[bo_table]'";
// 수정본 (꼭 필요한 9개만 select)
$sql = " select bo_table, bo_notice, bo_subject, bo_subject_len, bo_use_list_content, bo_new, bo_use_sideview, bo_use_comment, bo_hot, bo_use_search from $g4[board_table] where bo_table = '$row[bo_table]'";
$board = sql_fetch($sql);

★ $tmp_write_table의 불필요한 조회를 줄인다

// 원본 (수십개의 field를 select)
$sql = " select * from $tmp_write_table where wr_id = '$row[wr_id]' ";
// 수정본 (꼭 필요한 15개만 select)
$sql = " select wr_id, wr_subject, wr_option, wr_content, wr_comment, wr_parent, wr_datetime, wr_last, wr_homepage, wr_name, wr_reply, wr_link1, wr_link2, ca_name, wr_hit from $tmp_write_table where wr_id = '$row[wr_id]' ";

추천0