|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° Àбâ |
|
  2001-04-05 (22:13:50) from 211.109.190.84 |
|
|
  ÀÛ¼ºÀÎ : HappyCGI |
Á¶È¸¼ö : 4901    |
|
Á¦¸ñ : Mysql ÀÎÅؽºÅ° »ý¼º½Ã °Ë»ö¼Óµµ ÃøÁ¤°á°ú |
¾È³çÇϼ¼¿ä. ÇØÇÇCGI À±¿µ¿õÀÔ´Ï´Ù. 1°³ÀÇ Å×ÀÌºí¿¡ 10°³ÀÇ Ä÷³ÀÌ ÀÖ´Â »óÅÂÀ̱¸¿ä. ¿ì¼± 20¸¸°ÇÀÇ ±ÛÀ» ³Ö¾îµÎ¾ú½À´Ï´Ù.
int ¼Ó¼ºÀ» °¡Áø Ä÷³ÀÇ ÀÎÅؽº¸¦ ÇÏÁö ¾Ê°í ¾Æ·¡ Äõ¸®¸¦ ÁÖ¾ú½À´Ï´Ù. select * from forum_article order by inquire asc limit 10000,10; 2.95ÃÊ °É¸®³×¿ä.
inquire Ä÷³¿¡ À妽ºÅ°¸¦ Ãß°¡ÇÏ°í ´Ù½Ã °°Àº Äõ¸®¸¦ ÁÖ¾ú½À´Ï´Ù. 0.22ÃÊ °É¸®³×¿ä.
^^
Ä÷³ÀÇ ¼Ó¼ºÁß varchar ÀÏ °æ¿ì 3ÃÊ¿¡¼ 4ÃÊ°¡ °É¸®¸ç (À妽ÌÀ» Çصµ) order by °¡ µÎ°¡Áö ÀÌ»óÀÏ°æ¿ì (ex: order by number desc,thread asc) 6ÃÊ°¡·® °É¸®´Â ±º¿ä.
Å×½ºÆ®¼¹öÀÇ ¸Þ¸ð¸®´Â 256M À̸ç CPU´Â 350Mz ÀÔ´Ï´Ù.
HappyCGI's SIGN
| °³¹ßÀÚÀÇ ¹Ì´öÀº
°ÔÀ¸¸§(Laziness) ÂüÁö¸»±â(Impatience) ±³¸¸(Hubris) |
|
|
|
¸Þ¸ð |
|
³²°ÜÁø ¸Þ¸ð°¡ ¾ø½À´Ï´Ù.
|
|
   |
|
|