jQuery：Yahoo Autocomplete / Autosuggest(jQuery: Yahoo Autocomplete/Autosuggest)

 1）谢谢你的“EXPLAIN”。 我们所有人（包括你，我敢肯定） 知道问题是mysql必须将整数转换为字符串，并且必须为每一行执行此操作。 但你的“EXPLAIN”证明了这一点。 
 
 2）这是一篇关于EXPLAIN的简短文章： 
 
 
 
 
  
 http://www.lornajane.net/posts/2011/explaining-mysqls-explain 
 
 
 
 
 * possible_keys *显示哪些索引适用于此查询，并且键告诉我们实际使用了哪些-...最后， rows条目告诉我们MySQL必须查看多少行才能找到结果集。 
 
 
Search value:   key:        type:  ref:   rows:  
-------------   ---         ----   ----   ----
5107357058      NULL        ALL    NULL   6482116
'5107357058'    phoneNumber ref    const  2
 
 3）“ref”列是“与索引相比的列”。 在第二种情况下，将字符串文字（“常量”）'5107357058'与键“phoneNumber”进行比较。 在第一种情况下，没有可用的密钥（因为您的搜索条件是完全不同的类型）; 因此“ref”为NULL。 
 
 4）“类型”列是“连接类型”。 “Ref”表示“从该表中读取具有匹配索引值的所有行”（在本例中为2行）。 “ALL”勒芒“全表扫描”。 在这种情况下，这意味着600万行。 
 
 5）这是“EXPLAIN”的mysql文档： 
 
 
 
 http://dev.mysql.com/doc/refman/5.5/en/explain-output.html 
 

1) Thank you for the "EXPLAIN". We all (including you, I'm sure) knew that the problem was that mysql had to convert the integer to a string, and had to do it for each row. But your "EXPLAIN" proved it.
 
2) Here's a nice, short article about EXPLAIN:
 
 
 
 
  
http://www.lornajane.net/posts/2011/explaining-mysqls-explain
 
 
 
 
The *possible_keys* shows which indexes apply to this query and the key tells us which of those was actually used -... Finally the rows entry tell us how many rows MySQL had to look at to find the result set.
 
 
Search value:   key:        type:  ref:   rows:  
-------------   ---         ----   ----   ----
5107357058      NULL        ALL    NULL   6482116
'5107357058'    phoneNumber ref    const  2
 
3) The "ref" column is the "The columns compared to the index". In the second case, the string literal ("constant") '5107357058' was compared to the key "phoneNumber". In the first case, there was no usable key (because your search condition was a completely different type); hence "ref" was NULL.
 
4) The "type" column is "The join type". "Ref" means "All rows with matching index values are read from this table" (in this case, 2 rows). "ALL" mans "full table scan". Which in this case means 6 million rows.
 
5) Here's the mysql documentation for "EXPLAIN":
 
 
 
http://dev.mysql.com/doc/refman/5.5/en/explain-output.html