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

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-02 11:27:451148browse

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>
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn