53 ¹ø ±ÛÀÇ ´äÀå±Û: [MYSQL] LIKE vs INSTR() |
±Û¾´ÀÌ: »êÀÌ
[ȨÆäÀÌÁö]
|
±Û¾´³¯: 2003³â 08¿ù 20ÀÏ 12:20:31 ¼ö(¿ÀÈÄ) |
Á¶È¸: 9823 |
[MYSQL] LIKE vs INSTR()
0. ¹è°æ
1. ¿µ¹® °Ë»ö¾î Å×½ºÆ®
1-1. ¾Õ ºÎºÐ °Ë»ö
1-2. Áß°£ ºÎºÐ °Ë»ö
1-3. ³¡ ºÎºÐ °Ë»ö
2. ÇÑ±Û °Ë»ö¾î Å×½ºÆ®
2-1. ¾Õ ºÎºÐ °Ë»ö
2-2. Áß°£ ºÎºÐ °Ë»ö
2-3. ³¡ ºÎºÐ °Ë»ö
3. °á°ú ºñ±³(Ç¥)
3-1. ¿µ¹® °Ë»ö¾î °á°ú
3-2. ÇÑ±Û °Ë»ö¾î °á°ú
4. °á·Ð
5. Èıâ
---------------------------------------
0. ¹è°æ
TRUE ÀÎ °æ¿ì¸¸ Å×½ºÆ®ÇÑ °æ¿ìÀÓ.
... cols LIKE '%Çѱ۰˻ö¾î%'
... BINARY cols LIKE '%Çѱ۰˻ö¾î%'
À¥ °Ô½ÃÆÇ¿¡¼, ÈÄÀÚÀÇ °æ¿ì ¼Óµµ°¡ ¾à 3 ¹è, ¶Ç´Â ±× ÀÌ»ó ºü¸§
¸¶Âù°¡Áö·Î,
... cols LIKE '%¼ýÀÚÇüÁ¶ÇÕ%'
... BINARY cols LIKE '%¼ýÀÚÇüÁ¶ÇÕ%'
¼ýÀÚÀÇ °Ë»öµµ BINARY ·Î °Ë»öÇÒ °æ¿ì ºü¸§.
(Á¤¼öÇü¸¸ Å×½ºÆ®ÇØ º¸¾ÒÀ½)
1. ¿µ¹® °Ë»ö¾î Å×½ºÆ®
1-1. ¾Õ ºÎºÐ °Ë»ö
1) ´ë¼Ò¹®ÀÚ ±¸º°½Ã
DO BENCHMARK(1000000, BINARY 'MSIEdddddd' LIKE 'MSIE%');
0.47
DO BENCHMARK(1000000, INSTR('MSIEdddddd','MSIE'));
0.27
2) ´ë¼Ò¹®ÀÚ ±¸º°¾øÀÌ
DO BENCHMARK(1000000, 'MSIEdddddd' LIKE 'MSIE%');
0.66
DO BENCHMARK(1000000, INSTR(LOWER('MSIEdddddd'),LOWER('MSIE')));
1.86
1-2. Áß°£ ºÎºÐ °Ë»ö
1) ´ë¼Ò¹®ÀÚ ±¸º°½Ã
DO BENCHMARK(1000000, BINARY 'dddMSIEdddddd' LIKE '%MSIE%');
0.60
DO BENCHMARK(1000000, INSTR('dddMSIEdddddd','MSIE'));
0.44
2) ´ë¼Ò¹®ÀÚ ±¸º°¾øÀÌ
DO BENCHMARK(1000000, 'dddMSIEdddddd' LIKE '%MSIE%');
1.15
DO BENCHMARK(1000000, INSTR(LOWER('dddMSIEdddddd'),LOWER('MSIE')));
2.15
1-3. ³¡ ºÎºÐ °Ë»ö
1) ´ë¼Ò¹®ÀÚ ±¸º°½Ã
DO BENCHMARK(1000000, BINARY 'dddMSIE' LIKE '%MSIE');
0.56
DO BENCHMARK(1000000, INSTR('dddMSIE','MSIE'));
0.43
2) ´ë¼Ò¹®ÀÚ ±¸º°¾øÀÌ
DO BENCHMARK(1000000, 'dddMSIE' LIKE '%MSIE');
1.22
DO BENCHMARK(1000000, INSTR(LOWER('dddMSIE'),LOWER('MSIE')));
1.77
2. ÇÑ±Û °Ë»ö¾î Å×½ºÆ®
2-1. ¾ÕºÎºÐ °Ë»ö
1) ´ë¼Ò¹®ÀÚ ±¸º°½Ã
DO BENCHMARK(10000000, BINARY 'ÇÑ±Û Å×½ºÆ®' LIKE 'ÇѱÛ%');
Query OK, 0 rows affected (4.70 sec)
DO BENCHMARK(10000000, INSTR('ÇÑ±Û Å×½ºÆ®','ÇѱÛ'));
Query OK, 0 rows affected (2.73 sec)
2) ´ë¼Ò¹®ÀÚ ±¸º°¾øÀÌ
DO BENCHMARK(10000000, 'ÇÑ±Û Å×½ºÆ®' LIKE 'ÇѱÛ%');
Query OK, 0 rows affected (6.60 sec)
DO BENCHMARK(10000000, INSTR('ÇÑ±Û Å×½ºÆ®',LOWER('ÇѱÛ')));
Query OK, 0 rows affected (7.48 sec)
DO BENCHMARK(10000000, INSTR(LOWER('ÇÑ±Û Å×½ºÆ®'),'ÇѱÛ'));
Query OK, 0 rows affected (12.23 sec)
DO BENCHMARK(10000000, INSTR(LOWER('ÇÑ±Û Å×½ºÆ®'),LOWER('ÇѱÛ')));
Query OK, 0 rows affected (17.25 sec)
2-2. Áß°£ ºÎºÐ °Ë»ö
1) ´ë¼Ò¹®ÀÚ ±¸º°½Ã
DO BENCHMARK(10000000, BINARY 'Å×½ºÆ® ÇÑ±Û Å×½ºÆ®' LIKE '%ÇѱÛ%');
Query OK, 0 rows affected (6.63 sec)
DO BENCHMARK(10000000, INSTR('Å×½ºÆ® ÇÑ±Û Å×½ºÆ®','ÇѱÛ'));
Query OK, 0 rows affected (5.52 sec)
2) ´ë¼Ò¹®ÀÚ ±¸º°¾øÀÌ
DO BENCHMARK(10000000, 'Å×½ºÆ® ÇÑ±Û Å×½ºÆ®' LIKE '%ÇѱÛ%');
Query OK, 0 rows affected (19.50 sec)
DO BENCHMARK(10000000, INSTR('Å×½ºÆ® ÇÑ±Û Å×½ºÆ®',LOWER('ÇѱÛ')));
Query OK, 0 rows affected (10.60 sec)
DO BENCHMARK(10000000, INSTR(LOWER('Å×½ºÆ® ÇÑ±Û Å×½ºÆ®'),'ÇѱÛ'));
Query OK, 0 rows affected (18.39 sec)
DO BENCHMARK(10000000, INSTR(LOWER('Å×½ºÆ® ÇÑ±Û Å×½ºÆ®'),LOWER('ÇѱÛ')));
Query OK, 0 rows affected (23.25 sec)
2-3. ³¡ ºÎºÐ °Ë»ö
1) ´ë¼Ò¹®ÀÚ ±¸º°½Ã
DO BENCHMARK(10000000, BINARY 'Å×½ºÆ® ÇѱÛ' LIKE '%ÇѱÛ');
Query OK, 0 rows affected (6.40 sec)
DO BENCHMARK(10000000, INSTR('Å×½ºÆ® ÇѱÛ','ÇѱÛ'));
Query OK, 0 rows affected (5.51 sec)
2) ´ë¼Ò¹®ÀÚ ±¸º°¾øÀÌ
DO BENCHMARK(10000000, 'Å×½ºÆ® ÇѱÛ' LIKE '%ÇѱÛ');
Query OK, 0 rows affected (19.51 sec)
DO BENCHMARK(10000000, INSTR('Å×½ºÆ® ÇѱÛ',LOWER('ÇѱÛ')));
Query OK, 0 rows affected (10.60 sec)
DO BENCHMARK(10000000, INSTR(LOWER('Å×½ºÆ® ÇѱÛ'),'ÇѱÛ'));
Query OK, 0 rows affected (15.39 sec)
DO BENCHMARK(10000000, INSTR(LOWER('Å×½ºÆ® ÇѱÛ'),LOWER('ÇѱÛ')));
Query OK, 0 rows affected (20.32 sec)
3. °á°ú ºñ±³(Ç¥)
°¢ 5¹ø Å×½ºÆ® ÃÖ»ó,ÃÖÇÏ ¹ö¸®°í Áß°£°ª ¼±ÅÃ
3-1. ¿µ¹® °Ë»ö¾î °á°ú
<FONT FACE='±¼¸²Ã¼'>
+-----------+----------+-------------------+-------------------+--------------------
+
| | | ´ë¼Ò¹®ÀÚ ±¸º° (O) | ´ë¼Ò¹®ÀÚ ±¸º° (X) |
|
| ±¸ ºÐ | Å×½ºÆ® |---------+---------+---------+---------| ºñ°í
|
| | | LIKE | INSTR() | LIKE | INSTR() |
|
|-----------+----------+---------+---------+---------+---------+--------------------
|
| ¾ÕºÎºÐ°Ë»ö| 1,000,000| 0.47 | 0.27 | 0.66 | 1.86 |
|
| |10,000,000| 4.69 | 2.72 | 6.55 | 18.58 |
|
|-----------+----------+---------+---------+---------+---------+--------------------
|
| Áß°£ ºÎºÐ| 1,000,000| 0.60 | 0.44 | 1.15 | 2.15 |
|
| |10,000,000| 5.90 | 4.38 | 11.43 | 21.66 |
|
| |10,000,000| 8.38 | 18.65 | 37.46 | 53.59 | 51 bytes
|
|-----------+----------+---------+---------+---------+---------+--------------------
|
| µÞºÎºÐ°Ë»ö| 1,000,000| 0.56 | 0.43 | 1.22 | 1.77 |
|
| |10,000,000| 5.65 | 4.35 | 11.08 | 17.53 |
|
|-----------+----------+---------+---------+---------+---------+--------------------
|
| °á°ú | winner | | winner | |
|
+----------------------+---------+---------+---------+---------+--------------------
+
</FONT>
*ÁÖ) ´ÜÀ§ ÃÊ(seconds), °ªÀÌ ÀÛÀ»¼ö·Ï ¿ì¼¼
¿µ¹® °Ë»öÀº ´ë¼Ò¹®ÀÚ¸¦ ±¸º°ÇÏ´Â °æ¿ì¿¡ ÃÖ´Ü ½Ã°£ÀÌ °É¸².
´ë¼Ò¹®ÀÚ¸¦ ±¸º°ÇÏ´Â °Ë»ö¿¡¼´Â °Ë»öÇÒ µ¥ÀÌÅÍ ºÐÆ÷°¡ Áß¿äÇѵ¥,
¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸,
³ª¸ÓÁö´Â ºñ½ÁÇϰųª BINARY ... LIKE ¿¬»êÀÌ ¿ùµîÇÔ.
Áï,
°Ë»ö ´ë»ó ±æÀÌ°¡ ±æ¾îÁö°í µÚÂÊÀ¸·Î °Ë»öÇÒ ¼ö·Ï È®½ÇÈ÷ BINARY ... LIKE ¿¬»êÀÌ ´õ
ºü¸§.
´ë¼Ò¹®ÀÚ¸¦ ±¸º°ÇÏÁö ¾ÊÀ» °æ¿ì¿¡¼´Â,
¸ðµç °Ë»ö¿¡¼ LIKE ¿¬»êÀÌ ¾à 1.5 ¹è ÀÌ»ó ¿ì¼¼ÇÔ.
ÃÖ¾ÇÀÇ °æ¿ì´Â INSTR(LOWER(...),LOWER(...)) ·Î½á ÀÌ°ÍÀº LIKE ¿¬»êº¸´Ù
Àý´ëÀûÀ¸·Î ´À¸².
À¥ °Ô½ÃÆÇ°ú °°Àº °Ë»ö¿¡¼´Â, ´ëºÎºÐ ´ë¼Ò¹®ÀÚ¸¦ ±¸º°ÇÏÁö ¾Ê°í °Ë»öÇÏ´Â
°æ¿ì°¡ ¸¹À¸¹Ç·Î ¿µ¹® °Ë»öÀº LIKE ¿¬»êÀÌ ´õ À¯¸®ÇÔ.
3-2. ÇÑ±Û °Ë»ö¾î °á°ú
<FONT FACE='±¼¸²Ã¼'>
+-----------+----------+-------------------+----------------------------------------
+
| | | ´ë¼Ò¹®ÀÚ ±¸º° (O) | ´ë¼Ò¹®ÀÚ ±¸º° (X)
|
| ±¸ ºÐ | Å×½ºÆ®
|---------+---------+---------+---------+---------+----------|
| | | LIKE | INSTR() | LIKE
|INSTR(,L)|INSTR(L,)|INSTR(L,L)|
|-----------+----------+---------+---------+---------+---------+---------+----------
|
| ¾ÕºÎºÐ°Ë»ö|10,000,000|
4.70 | 2.73 | 6.60 | 7.48 | 12.23 | 17.25 |
|-----------+----------+---------+---------+---------+---------+---------+----------
|
| Áß°£ ºÎºÐ|10,000,000| 6.63 | 5.52 | 19.50 | 10.60 | 18.39 | 23.25
|
| |10,000,000| 21.40 | 29.62 | 95.39 | 35.19 | 66.47 | 71.71
|
|-----------+----------+---------+---------+---------+---------+---------+----------
|
| µÞºÎºÐ°Ë»ö|10,000,000|
6.40 | 5.51 | 19.51 | 10.60 | 15.39 | 20.32 |
|-----------+----------+---------+---------+---------+---------+---------+----------
|
| °á°ú | winner | | |(winnner)| |
|
+----------------------+---------+---------+---------+---------+---------+----------
+
</FONT>
*ÁÖ) ´ÜÀ§ ÃÊ(seconds), °ªÀÌ ÀÛÀ»¼ö·Ï ¿ì¼¼
ÇѱÛÀº ¿Ü°üÀûÀ¸·Î ´ë¼Ò¹®ÀÚ¸¦ ±¸º°ÇÏÁö´Â ¾ÊÁö¸¸, MySQL ÀÇ ³»ºÎÀû ¿¬»ê¿¡¼,
´ë¼Ò¹®ÀÚ¸¦ ±¸º°Çϵµ·Ï ½ÇÇàÇÒ °æ¿ì, ¸ðµç ¸é¿¡¼ Ç×»ó ¿ì¼¼ÇÔ.
(*** ÀÌ°ÍÀº 'ÇѱÛ'»Ó¸¸ ¾Æ´Ï¶ó '¼ýÀÚ' ÀÚ·áÇüÀÇ °æ¿ìµµ ±×´ë·Î Àû¿ëµÊ ***)
ÀÏ·Ê·Î, ¾ÕÀÇ Ç¥ÀÇ 'Áß°£ ºÎºÐ' °Ë»ö¿¡¼ BINARRY ... LIKE ´Â LIKE º¸´Ù
¾à 3 ¹è ÀÌ»ó ºü¸£´Ù´Â °ÍÀ» ¾Ë ¼ö ÀÖ°í INSTR() ÇÔ¼ö ¿ª½Ã ¸¶Âù°¡ÁöÀÓ.
¿µ¹®°Ë»ö°ú ¸¶Âù°¡Áö·Î ¾ÕºÎºÐ °Ë»öÀ» Á¦¿ÜÇÏ°í, °Ë»ö ´ë»ó ±æÀÌ°¡ ±æ¾îÁö°í
µÚÂÊÀ¸·Î °Ë»öÇÒ ¼ö·Ï È®½ÇÈ÷ BINARY ... LIKE ¿¬»êÀÌ ´õ ºü¸§.
¿ª½Ã ÃÖ¾ÇÀÇ °æ¿ì´Â ÃÖ¾ÇÀÇ °æ¿ì´Â INSET(LOWER(...),LOWER(...)) ÀÓ.
4. °á·Ð
¾ÕÀÇ °Ë»ö Å×½ºÆ®¿Í ±× °á°ú¿¡¼ ¾Ë ¼ö ÀÖµíÀÌ, LIKE ¿¬»êÀÌ ´ëºÎºÐ
À¯¸®ÇÏÁö¸¸, LIKE ¿¬»êÀÌ ´õ À¯¸®ÇÑ°¡ ¾Æ´Ï¸é INSTR() ¿¬»êÀÌ ´õ À¯¸®ÇÑ°¡¿¡
´ëÇÑ È®´äÀº ¾ø½À´Ï´Ù.
ÀÌ°ÍÀº, °Ë»öÇÒ Å¸°Ù(´ëºÎºÐ columns)ÀÇ ÀÚ·áÇüÀÌ ¾î¶² ¹®ÀÚ¿(¹®ÀÚ¼Â)°ú
¾î¶² ÇüÅ·ΠºÐÆ÷µÇ¾î ÀÖ´À³Ä¿¡ µû¶ó¼ ¼ÓµµÂ÷ÀÌ°¡ ³¯ »ÓÀÔ´Ï´Ù.
±×·¯³ª,
´ëºÎºÐ À¥ °Ô½ÃÆÇ °°Àº °æ¿ì´Â ã°íÀÚÇÏ´Â ´Ü¾î ¹è¿ ÇüÅ°¡ ¹«ÀÛÀ§·Î ºÐÆ÷µÇ¾î
ÀÖ°í, ¶ÇÇÑ »ç¿ëÀÚ °Ë»ö¾î ¿ª½Ã ¹«ÀÛÀ§ ÀÓÀÇÀÇ ´Ü¾îÀֱ⠶§¹®¿¡ ¾Õ¿¡¼
Å×½ºÆ®ÇÑ 'Áß°£ºÎºÐ °Ë»ö'ÀÌ ½ÇÁ¦ ½Ç¹«¿¡¼ Àû¿ë°¡´ÉÇÑ ¹æ¹ýÀÓÀ»
½Ã»çÇÏ°í ÀÖ½À´Ï´Ù.
°Ë»öÇÒ column ¿ª½Ã, ´ëºÎºÐ 32 ¶Ç´Â 255 bytes(ƯÀÌÇÑ °æ¿ì Á¦¿Ü) ÀÌ»óÀ̶ó´Â
Á¡¿¡¼ ´Ù¸§°ú °°Àº ¹æ¹ýÀ» ±ÇÀåÇÕ´Ï´Ù.
<FONT FACE='±¼¸²Ã¼'>
+----------------+------------------------+------------------------------+
| column ÇüÅ | ±ÇÀå (32 bytes ÀÌ»ó) | ¿¹Á¦ |
|----------------+------------------------+------------------------------|
| ´ë¹®ÀÚ¸¸ | BINARY str LIKE substr | BINARY cols LIKE '%KWD%' |
| ¼Ò¹®ÀÚ¸¸ | BINARY str LIKE substr | BINARY cols LIKE '%kwd%' |
| ´ë+¼Ò¹®ÀÚ | str LIKE substr | cols LIKE '%kWd%' |
|----------------+------------------------+------------------------------|
| Çѱ۸¸ | BINARY str LIKE substr | BINARY cols LIKE '%ÇѱÛ%' |
| ÇѱÛ+´ë¹®ÀÚ | BINARY str LIKE substr | BINARY cols LIKE '%ÇѱÛKWD%' |
| ÇѱÛ+¼Ò¹®ÀÚ | BINARY str LIKE substr | BINARY cols LIKE '%ÇѱÛkwd%' |
| ÇѱÛ+´ë+¼Ò¹®ÀÚ | str LIKE substr | cols LIKE '%ÇѱÛkWd%' |
+----------------+------------------------+------------------------------+
</FONT>
*ÁÖ) column length °¡ 255 bytes ÀÌ»ó, Áß°£ °Ë»öÀ̶ó´Â °¡Á¤
*ÁÖ) 'kwd' ´Â »ç¿ëÀÚ°¡ °Ë»öÇÏ´Â ÀÓÀÇÀÇ ´Ü¾î
PHP Àû¿ë ¿¹)
<?php
...
$kwd = '»ç¿ëÀÚ ÀÓÀÇ °Ë»ö¾î'; // add quoted string
$binary = ''; // ÃʱⰪ
if(!preg_match('/[a-zA-Z]/',$kwd)) // ¿µ¹®¹®ÀÚ°¡ µé¾î°¡ ÀÖ´Â ¾Ê´Â °æ¿ì
{ $binary = 'BINARY'; }
$sql = "SELECT ... WHERE $binary board.text LIKE '%$kwd%' ...";
...
?>
¸¸¾à, °Ë»öÇÒ column ÀÌ 32 bytes ÀÌÇÏÀÌ°í, ¶ÇÇÑ °Ë»öÀ§Ä¡°¡ Áß°£ÀÌ ¾Æ´Ñ
¾ÕÀ̰ųª µÚÂÊÀ̶ó¸é, ¾ÕÀÇ °á°úÇ¥¸¦ º¸°í ÀûÀýÇÑ ¹æ¹ýÀ» ¼±ÅÃÇØ¾ß ÇÕ´Ï´Ù.
5. Èıâ
¾øµû¾Ó.......
- Å×½ºÆ® ¹öÀü Ç¥½Ã ´©¶ô <--- 3.23.55
- str LIKE substr (OK)
- BINARY str LIKE substr (OK)
- str LIKE BINARY substr (´©¶ô)
- BINARY str LIKE BINARY substr (´©¶ô)
- INSTR(str, substr) (OK)
- INSTR(BINARY str, substr) (´©¶ô)
- INSTR(str, BINARY substr) (´©¶ô)
- INSTR(BINARY str, BINARY substr) (´©¶ô)
...
4.0.x ¿¡¼ `str LIKE substr' ¿¬»êÀÌ »ó´çÇÑ ÁøÀüÀÌ
ÀÖ±º¿ä. ¾à 2~4¹è ÀÌ»ó Á¤µµ·Î Çâ»ó.
ÇÑ±Û °Ë»ö ºÎºÐ¿¡¼,
3.23.x ¿Í 4.0.x ¸¦ ÅëƲ¾î ¾ÆÁÖ ±Ù¼ÒÇÑ Â÷ÀÌ·Î(µµÅ丮 Å°Àç±â)
1. INSTR(BINARY str, substr) <-- winner
2. INSTR(str, BINARY substr) <-- winner of the semifinals
3. INSTR(BINARY str, BINARY substr)
4. BINARY str LIKE substr
5. str LIKE BINARY substr
6. BINARY str LIKE BINARY substr
(¿©±â±îÁö°¡ °ÅÀÇ ´ëµ¿¼ÒÀÌ....)
7. str LIKE substr <--- 4.0.x
8. INSTR(str, substr) <--- 3.23.x, 4.0.x
9. str LIKE substr <--- 3.23.x
------
3.23.x
DO BENCHMARK(10000000, '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR() ÇÔ¼ö°¡
ºü¸£Áö¸¸' LIKE '%±æÀÌ%');
Query OK, 0 rows affected (47.02 sec)
DO BENCHMARK(10000000, BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸' LIKE '%±æÀÌ%');
Query OK, 0 rows affected (7.98 sec)
DO BENCHMARK(10000000, '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR() ÇÔ¼ö°¡
ºü¸£Áö¸¸' LIKE BINARY '%±æÀÌ%');
Query OK, 0 rows affected (7.93 sec)
DO BENCHMARK(10000000, BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸' LIKE BINARY '%±æÀÌ%');
Query OK, 0 rows affected (8.42 sec)
DO BENCHMARK(10000000, INSTR('¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸','±æÀÌ'));
Query OK, 0 rows affected (14.05 sec)
DO BENCHMARK(10000000, INSTR(BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î
INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸','±æÀÌ'));
Query OK, 0 rows affected (6.75 sec)
DO BENCHMARK(10000000, INSTR('¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸',BINARY '±æÀÌ'));
Query OK, 0 rows affected (6.95 sec)
DO BENCHMARK(10000000, INSTR(BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î
INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸',bINARY '±æÀÌ'));
Query OK, 0 rows affected (7.32 sec)
DO BENCHMARK(10000000, INSTR(LOWER('¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î
INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸'),LOWER('±æÀÌ')));
Query OK, 0 rows affected (54.91 sec)
4.0.9
DO BENCHMARK(10000000, '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR() ÇÔ¼ö°¡
ºü¸£Áö¸¸' LIKE '%±æÀÌ%');
Query OK, 0 rows affected (11.40 sec)
DO BENCHMARK(10000000, BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸' LIKE '%±æÀÌ%');
Query OK, 0 rows affected (7.64 sec)
DO BENCHMARK(10000000, '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR() ÇÔ¼ö°¡
ºü¸£Áö¸¸' LIKE BINARY '%±æÀÌ%');
Query OK, 0 rows affected (7.76 sec)
DO BENCHMARK(10000000, BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸' LIKE BINARY '%±æÀÌ%');
Query OK, 0 rows affected (9.26 sec)
DO BENCHMARK(10000000, INSTR('¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸','±æÀÌ'));
Query OK, 0 rows affected (14.01 sec)
DO BENCHMARK(10000000, INSTR(BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î
INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸','±æÀÌ'));
Query OK, 0 rows affected (6.75 sec)
DO BENCHMARK(10000000, INSTR('¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î INSTR()
ÇÔ¼ö°¡ ºü¸£Áö¸¸',BINARY '±æÀÌ'));
Query OK, 0 rows affected (6.95 sec)
DO BENCHMARK(10000000, INSTR(BINARY '¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î
INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸',bINARY '±æÀÌ'));
Query OK, 0 rows affected (7.32 sec)
DO BENCHMARK(10000000, INSTR(LOWER('¾ÕºÎºÐ °Ë»ö¿¡¼´Â Àý´ëÀû(±æÀÌ¿¡ »ó°ü¾øÀÌ)À¸·Î
INSTR() ÇÔ¼ö°¡ ºü¸£Áö¸¸'),LOWER('±æÀÌ')));
Query OK, 0 rows affected (54.91 sec)
-----
EOF
|
ÀÌÀü±Û : [MYSQL][PHP][APACHE]
´ÙÀ½±Û : [APACHE] HTTP Request Á¦ÇÑ(400, 414, GET)
|
from 61.254.75.40
JS(Redhands)Board 0.4 +@
|
|