CI调用存储过程很慢怎么提速,mysql存储过程本身执行很快,但是在php调用就要0.8s
Release: 2016-06-02 11:27:45
Original
1112 people have browsed it
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>
Copy after login
Statement of this Website
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
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31