|
Total related article : 2 |
|
µî·ÏÀÏ: | 2001-04-05 |
½Ã°£: | 22:13:50 |
Á¶È¸¼ö: | 4899 |
from: | 211.109.190.84 |
|
Mysql ÀÎÅؽºÅ° »ý¼º½Ã °Ë»ö¼Óµµ ÃøÁ¤°á°ú |
±Û¾´ÀÌ : HappyCGI |
|
¾È³çÇϼ¼¿ä. ÇØÇÇ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 ÀÔ´Ï´Ù.
|
|
   |
|
µî·ÏÀÏ: | 2001-04-07 |
½Ã°£: | 02:35:07 |
Á¶È¸¼ö: | 6449 |
from: | 211.187.191.138 |
|
Mysql int¿Í varchar ±×¸®°í order by °Ë»ö¼ÓµµÂ÷ |
±Û¾´ÀÌ : HappyCGI |
|
¾È³çÇϼ¼¿ä. ÇØÇÇCGI À¥¸¶½ºÅÍ À±¿µ¿õÀÔ´Ï´Ù. ¿äÁò ÇÑâ mysql ¼ÓµµÂ÷¿¡ ´ëÇؼ ±Ã±ÝÀÌ ÁõÆøµÇ¾ú³×¿ä. ^^ ¿À´Ã Á¦°¡ Å×½ºÆ®Çغ» ȯ°æÀº ¸®´ª½º/¸Þ¸ð¸®256M/CPU 700Mz ÀÔ´Ï´Ù. Å×À̺íÀÇ Ä÷³Àº ¾à 11°³Á¤µµ±¸¿ä. 50¸¸°ÇÀÇ ±ÛÀ» °Á¦·Î Áý¾î³Ö¾ú½À´Ï´Ù.
select ¹®À» ¼öÇàÇÔ¿¡ ÀÖ¾î¼ limit ÇÔ¼ö´Â ¼Óµµ¿¡ ¿µÇâÀÌ ¾ø¾ú½À´Ï´Ù. ÆäÀÌÁö ºÐÇҽà ²À limit¸¦ ½á¾ß ÇÏ°Ú´Ù´Â »ý°¢ÀÌ µé¾ú±¸¿ä. (´ç¿¬ÇÏÁö¸¸)
int Ä÷³ (number)À» order by ¾øÀÌ ÀÐÀ¸¸é 0.00ÃÊ´ë order by desc ÇßÀ» °æ¿ì 2.3 ÃÊ´ë°¡ ³ª¿À´Â±º¿ä. (number´Â ÀÍÅؽº ½ÃÅ°Áö ¾ÊÀ½ -> ½ÃÄѼ Çغ»°á°ú 0.00ÃÊ) varchar Ä÷³ (title)À» order by ÇßÀ» °æ¿ì 3.5ÃÊ´ë int ¿Í varchar Ä÷³À» µ¿½Ã¿¡ order by ÇßÀ» °æ¿ì 3.5ÃÊ È¤Àº ±× ÀÌ»ó. int Ä÷³°ú double Ä÷³ µ¿½Ã¿¡ order by ÇßÀ» °æ¿ì 2.7ÃÊ´ë ȤÀº ±× ÀÌ»ó
Á¤¸®¸¦ Çغ¸¸é... 1.À妽ÌÀº ²À ½ÃÅ°ÀÚ. 2.double µµ varchar¿Í ºñ½ÁÇÑ ¼Óµµ¸¦ °¡Áø´Ù. order by ½Ã µÉ¼ö ÀÖÀ¸¸é »©ÀÚ. 3.limit´Â select ¼Óµµ¿¡ °ÅÀÇ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê´Â´Ù.
ÀÌ»óÀÔ´Ï´Ù. ^^
¿À¶óŬÀÌ ½½½½ ŽÀÌ ³ª±â ½ÃÀÛÇÏ´Â ±º¿ä. ^^
|
|
   |