首頁 >後端開發 >php教程 >CI调用存储过程很慢怎么提速,mysql存储过程本身执行很快,但是在php调用就要0.8s

CI调用存储过程很慢怎么提速,mysql存储过程本身执行很快,但是在php调用就要0.8s

WBOY
WBOY原創
2016-06-02 11:27:451112瀏覽

mysqlphp存储

<code>                            $this -> db -> reconnect();                            $mysqli = new mysqli();                            $mysqli -> query("SET NAMES utf8");                            if (mysqli_connect_errno()) {                                    printf('Connect failed: %s\n', mysqli_connect_error());                                    exit();                            }                            if($set){                                    $mysqli ->multi_query("SET {$set} ");                            }                            //$query  = 'CALL p_MyFrontAndBackListTie(2)';                            /* execute multi query */                            if ($mysqli -> multi_query($query)) {                                    do {                                            /* store first result set */                                            if ($result = $mysqli -> store_result()) {                                                     while ($row = $result -> fetch_all()) {                                                            $all_result[] = $row;                                                      }                                                    $result -> free();                                            }                                    }                                    while ($mysqli -> next_result());                            }                                    /* close connection */                            $mysqli -> close();                            return $all_result;</code>
陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn