ÃÖ±Ù °Ô½ÃÆÇ ¼Óµµ ºü¸£°Ô ÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.
ȨÆäÀÌÁö¿¡ Á¦·Îº¸µå °Ô½ÃÆÇÀ» ÀÌ¿ëÇÏ¿© php ÇÁ·Î±×·¥À» ¸¹ÀÌ ÇϽʴϴÙ.
ƯÈ÷ °Ô½Ã¹°ÀÌ ¸¹¾ÆÁú ¼ö·Ï ÃÖ±Ù °Ô½Ã¹°À» ·ÎµåÇϴµ¥ ½Ã°£ÀÌ ¿À·¡ °É¸²À» ¸¹ÀÌ ´À³¢½Ã°Ô µÉ °ÍÀÔ´Ï´Ù.
±× ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ¿©·¯°¡Áö·Î ¾Ë¾Æ º¸¾Ò´õ´Ï ¿øÀÎÀº ¹Ù·Î select ¹®¿¡¼ »ç¿ëÇÏ´Â order by ¿¡ ÀÖ¾ú½À´Ï´Ù.
¿¹) select * from zetyx_board_free where is_secret=0 and father=0 order by no desc limit 10
order by ¿¡ ÀÇÇؼ °Ô½Ã¹°ÀÌ Á¤·ÄÇϴµ¥ °É¸®´Â ½Ã°£Àº n^2 (n ÀÇ Á¦°ö) ¿¡ ºñ·ÊÇÕ´Ï´Ù.
Áï, °Ô½Ã¹°ÀÌ 10 °³ÀÏ °æ¿ì 100 ¿¡ ÇØ´çÇÏ´Â ½Ã°£ÀÌ °É¸°´Ù¸é, °Ô½Ã¹°ÀÌ 1000°³ÀÎ °æ¿ì 1,000,000 ¿¡ ÇØ´çÇÏ´Â ½Ã°£ÀÌ °É¸°´Ù´Â °ÍÀÌÁÒ.
½ÇÁ¦·Î ÃÖ±Ù °Ô½Ã¹° ¹øÈ£ ( no Çʵå) °¡ 4000 ¹øÀÎ °Ô½Ã¹°ÀÇ ÃÖ±Ù ¸®½ºÆ®¸¦ ±¸ÇØ¿À´Âµ¥ 10ÃÊ³Ñ°Ô °É¸° Àûµµ ÀÖ¾ú½À´Ï´Ù. (Çѹø ±¸ÇÑ ´ÙÀ½¿¡´Â DB ¿¡ ij½Ã°¡ ÀúÀåµÇ¾î ºü¸£°Ô ±¸ÇÏÁö¸¸...)
ÀÌ·± ¹®Á¦¸¦ ÇØ°áÇϱâ À§Çؼ °¡Àå ÃÖ±ÙÀÇ °Ô½Ã¹° ¸î°³¸¦ °¡Á®¿Í¼ ±× °Í¿¡ ´ëÇؼ order by ¸¦ Àû¿ëÇÏ´Â ¹æ¹ýÀ¸·Î ¼Óµµ¸¦ Çâ»ó ½Ãų ¼ö ÀÖ½À´Ï´Ù.
¾Æ·¡ÀÇ ³»¿ëÀ» Àû¿ëÇÑ µÚ¿¡´Â ¾öû³ È¿°ú¸¦ º¸¾Ò½À´Ï´Ù. °ÅÀÇ ´©¸£ÀÚ¸¶ÀÚ È¸éÀÌ ¶ã Á¤µµÀÇ ¼Óµµ Çâ»óÀ» °¡Á®¿Ô½À´Ï´Ù.
Á¦·Îº¸µå °Ô½ÃÆÇÀ» »ç¿ëÇÏ½Å´Ù¸é ²À Àû¿ëÇϼż ȨÆäÀÌÁö 󸮼ӵµµµ Çâ»ó½ÃÅ°½Ã°í, ¼¹ö ºÎÇϵµ ÁÙ¿© ÁݽôÙ.
--------------------------------------------------------------------
outlogin.php ÀÇ print_bbs ÇÔ¼ö¿¡ ÆĶõ »öÀ¸·Î Ç¥½ÃµÈ ºÎºÐÀ» »ðÀÔÇÏ½Ã¸é µË´Ï´Ù.
function print_bbs(...)
...
if($setup[use_alllist]) $target = "zboard.php?id=".$id;
else $target = "view.php?id=".$id;
$result = mysql_query("select * from $t_board"."_$id where is_secret=0 and father=0 order by no desc limit $num", $connect) or die(mysql_error());
----------------------------------------------------------------------
function print_bbs(...)
...
if($setup[use_alllist]) $target = "zboard.php?id=".$id;
else $target = "view.php?id=".$id;
// speed up by hankawi
$tmp = mysql_fetch_array(mysql_query("select max(no) from $t_board"."_$id"));
$max_no = $tmp[0];
if ($max_no > 500) { // °Ô½Ã¹° °³¼ö°¡ 500°³ ÀÌ»óÀ϶§¸¸
$mylimit = $max_no - 100; // ÃÖÁ¾ 100°³¸¦ ´ë»óÀ¸·Î
$speedup = "no>$mylimit and";
} else {
$speedup = "";
}
$result = mysql_query("select * from $t_board"."_$id where ".$speedup." is_secret=0 and father=0 order by no desc limit $num", $connect) or die(mysql_error());
//
ÁÖÀÇ ÇϽǰÍÀº $id where°ø¹é".$speedup."°ø¹éis_secret=0 °ø¹éºÎºÐÀÔ´Ï´Ù.
|
¼£·Ò~
³! ÀÚÀ¯ÀÎ... |
|
|