PHP:查询MySQL最快的方法是什么?因为PDO太慢了 [英] PHP: What's the fastest way to query MySQL? Because PDO is painfully slow
本文介绍了PHP:查询MySQL最快的方法是什么?因为PDO太慢了的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要执行一个简单的查询.
I need to perform a simply query.
从字面上看,我要做的就是:
Literally, all I need to perform is:
SELECT price, sqft, zipcode FROM homes WHERE home_id = X
当我使用PHP PDO 时(建议阅读此方法是连接到MySQL数据库的推荐方法),仅创建连接就需要花费 610ms .
When I use PHP PDO, which I've read is the recommended way to connect to a MySQL database, simply creating the connection takes a measured 610ms.
我的代码如下:
try {
$conn_str = DB . ':host=' . DB_HOST . ';dbname=' . DB_NAME;
$dbh = new PDO($conn_str, DB_USERNAME, DB_PASSWORD);
$params = array();
$sql = 'SELECT price, sqft, zipcode FROM homes WHERE home_id = :home_id';
$params[':home_id'] = X;
$stmt = $dbh->prepare($sql);
$stmt->execute($params);
$result_set = $stmt->fetchAll(PDO::FETCH_ASSOC);
// json output
ob_start("ob_gzhandler");
header('Content-type: text/javascript; charset=utf-8');
print "{'homes' : ";
print json_encode( $result_set );
print '}';
ob_end_flush();
$dbh = null;
} catch (PDOException $e) {
die('Unable to connect');
}
问题:对我来说,连接到MySQL数据库以执行上述查询的最快方法是什么?
Question: What's the fastest way for me to connect to my MySQL database to perform the query above?
推荐答案
最快:
mysqli_connect("servername", "user", "pass") or die("can't connect");
mysqli_select_db("dbname") or die("can't select database");
list($price, $sqft, $zipcode) = mysqli_fetch_array(mysqli_query("SELECT price, sqft, zipcode FROM homes WHERE home_id = ".mysqli_real_escape_string($home_id)));
::现在使用mysqli代替mysqli.
: Now using mysqli instead of mysql.
这篇关于PHP:查询MySQL最快的方法是什么?因为PDO太慢了的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文