開発環境ã§è‡ªå‹•ã§SQLã«Explainã‚’ã‹ã‘るコンãƒãƒ¼ãƒãƒ³ãƒˆ - cakephperã®æ—¥è¨˜(CakePHP, Laravel, PHP)CakePHP 1.2.1を使ã£ã¦ã¾ã™ã€‚ CakePHPã¯config/core.phpã®debug値を2ã«ã™ã‚‹ã¨ã€ç”»é¢ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸéš›ã«ç™ºè¡Œã•ã‚ŒãŸSQLæ–‡ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ã“ã‚Œã«åŠ ãˆã¦ã€ç™ºè¡Œã—ãŸSQLæ–‡ã«Explainã‚’ã‹ã‘ã¦ãã®çµæžœã‚’è¿½åŠ è¡¨ç¤ºã™ã‚‹ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚’作りã¾ã—ãŸã€‚ 動作ãƒã‚§ãƒƒã‚¯ã¯MySQLã§ã—ã¾ã—ãŸãŒã€explainを使ãˆã‚‹Postgresãªã‚“ã‹ã§ã‚‚å‹•ãã¨æ€ã„ã¾ã™ã€‚Oracleã¨ã‹explain planã¨ã‹ã‚„らãªãゃã„ã‘ãªã„ã£ã½ã„ã®ã§ã€ãŸã¶ã‚“å‹•ãã¾ã›ã‚“。 Explainã®èª¬æ˜Žãªã©ã¯ä¸‹è¨˜ã‚’å‚ç…§(from opparaã•ã‚“ブãƒã‚°) http://dev.mysql.com/doc/refman/5.1/ja/explain.html http://blog.livedoor.jp/nipotan/archives/3743275.html http://dev.seesaa.ne
{{#tags}}- {{label}}
{{/tags}}