Index 很重要…

Posted on November 20, 2008 by Gea-Suan Lin

還好即時發現，差點撐不過今天晚上 -_-

簡單先找出最吃 CPU resource 的 SQL query，針對他的 WHERE 條件加上適當的 Index 後：

這樣就爭取到調整的時間了…

This entry was posted in Computer, Database, Murmuring, MySQL, Software. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>