blocks|key|1457023|text|一些快速计时表明PDO在连接时稍微快一些。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1457024|$start+=+microtime(true);
for($i=0;+$i<10000;+%2B%2B$i)+{

++++try+{
++++++++$db+=+new+PDO($dsn,+$user,+$password);
++++}+catch+(PDOException+$e)+{
++++++++echo+'Connection+failed:+'+.+$e->getMessage()."\n";
++++}
++++$db+=+null;
}

$pdotime+=+microtime(true)+-+$start;
echo+"PDO+time:+".$pdotime."\n";

$start+=+microtime(true);
for($i=0;+$i<10000;+%2B%2B$i)+{
++++$db+=+mysql_connect($host,+$user,+$password);
++++if(!$db)+{
++++++++echo+"Connection+failed\n";
++++}
++++if(!mysql_select_db($schema,+$db))+{
++++++++echo+"Error:+".mysql_error()."\n";
++++}
++++mysql_close($db);
}

$rawtime+=+microtime(true)+-+$start;
echo+"Raw+time:+".$rawtime."\n";|code-block|syntax|javascript|1457025|产生的结果如下|1457026|PDO+time:+0.77983117103577
Raw+time:+0.8918719291687

PDO+time:+0.7866849899292
Raw+time:+0.8954758644104

PDO+time:+0.77420806884766
Raw+time:+0.90708494186401

PDO+time:+0.77484893798828
Raw+time:+0.90069103240967|1457027|无论如何，速度差异都是微不足道的；建立网络连接可能比PDO产生的任何开销要长得多，特别是当mysql服务器在另一台主机上时。|1457028|您自己提到了使用PDO的所有理由。实际上，千万不要直接使用mysql_*函数，无论是使用PDO，还是使用some+other+library。|offset|length|1457029|entityMap|0|LINK|mutability|MUTABLE|url|http://pear.php.net/package/MDB2/redirected|1|2|http://pear.php.net/package/DB_DataObject^0|0|0|0|0|0|1G|4|0|1L|5|1|1R|7|2|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|13|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|15|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|16|8|@]|9|@$O|17|P|18|1|19]|$O|1A|P|1B|1|1C]|$O|1D|P|1E|1|1F]]|A|$]]|$1|Q|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|X]]|Z|$5|T|U|V|A|$W|10]]]]

Some quick timings indicate PDO is slightly faster at connecting.

<pre><code>$start = microtime(true);
for($i=0; $i&lt;10000; ++$i) {

 try {
 $db = new PDO($dsn, $user, $password);
 } catch (PDOException $e) {
 echo 'Connection failed: ' . $e-&gt;getMessage()."\n";
 }
 $db = null;
}

$pdotime = microtime(true) - $start;
echo "PDO time: ".$pdotime."\n";

$start = microtime(true);
for($i=0; $i&lt;10000; ++$i) {
 $db = mysql_connect($host, $user, $password);
 if(!$db) {
 echo "Connection failed\n";
 }
 if(!mysql_select_db($schema, $db)) {
 echo "Error: ".mysql_error()."\n";
 }
 mysql_close($db);
}

$rawtime = microtime(true) - $start;
echo "Raw time: ".$rawtime."\n";
</code></pre>

Gives results like 

<pre><code>PDO time: 0.77983117103577
Raw time: 0.8918719291687

PDO time: 0.7866849899292
Raw time: 0.8954758644104

PDO time: 0.77420806884766
Raw time: 0.90708494186401

PDO time: 0.77484893798828
Raw time: 0.90069103240967
</code></pre>

The speed difference will be negligible anyway; establishing a network connection will likely take a LOT longer than any overhead incurred by PDO, especially if the mysql server is on another host.

You mentioned all the reasons to use PDO yourself. Really, never use the mysql_* functions directly, either use PDO, or use <a href="http://pear.php.net/package/MDB2/redirected" rel="noreferrer" title="MDB2">some</a> <a href="http://pear.php.net/package/MDB2/redirected" rel="noreferrer" title="MDB2">other</a> <a href="http://pear.php.net/package/DB_DataObject" rel="noreferrer" title="DB_DataObject">library</a>.

blocks|key|1457108|text|如果性能对你来说不是一个“真正的问题”，你应该使用PDO。性能差别很小，而且PDO有一个非常好的和可移植的跨数据库接口，在您需要使用多个数据库驱动程序的情况下，它可以为您省去一些麻烦。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1457109|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If performance isn't a "real problem" for you, you should use PDO. The performance differs by small margins, and PDO has a very nice and portable cross-database interface wich can save you some headaches in case you need to use several database drivers.

blocks|key|1242379|text|PDO比mysql_*慢一点，但它有很好的可移植性。PDO提供跨多个数据库的单一接口。这意味着你可以使用多个数据库，而不需要为mysql使用mysql_query，为MS+sql使用mssql_query等。一直都是。无论您使用的是哪种DB驱动程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1242380|因此，对于较大或可移植的项目，PDO更可取。甚至zend框架也使用PDO。|1242381|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

PDO is a bit slower than the mysql_*
But it has great portability. PDO provides single interface across multiple databases. That means you can use multiple DB without using mysql_query for mysql, mssql_query for MS sql etc. Just use something like $db->query("INSERT INTO...") always. No matter what DB driver you are using.

So, for larger or portable project PDO is preferable. Even zend framework use PDO.

blocks|key|1457198|text|我通常会推荐使用PDO，除非有特定的原因，你不能。如果两者之间没有小的区别，并且您没有理由不使用PDO，那么我相信在您的应用程序中使用DB抽象的实践会比仅仅因为它存在而使用mysql_*更好。我会说让最佳实践取胜。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1457199|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I would generally recommend using PDO unless there is a specific reason you cannot. If there is no little difference between the two and you have no reason not to use PDO, I believe it would be better to get into the practice of using DB abstraction in your applications than going with mysql_* simply because it is there. I would say let best practice win.

blocks|key|1242470|text|在这两种情况下，您都从相同的mySQL服务器调用相同的Php服务器...所以你不会注意到很多不同之处。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1242471|如果您想要良好的性能，可以考虑缓存(memcache或简单的Php文件...)并建立一个良好的数据库结构(索引...)|1242472|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In both cases, you call the same mySQL server from the same Php server ... so you cannot notice a lot of difference.

If you want good performance, think about cache (memcache or simple Php file ...) and make a good data base structure (INDEX ...)

blocks|key|1242525|text|从PHP5.5.0开始，mysql_connect函数已被弃用，与大多数已弃用功能一样，它将被删除。因此，比起mysql_connect，更喜欢使用PDO_MySQL+(或其他替代的MySQLi+)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1242526|来源：http://php.net/manual/en/function.mysql-connect.php|1242527|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/ref.pdo-mysql.php|1|http://php.net/manual/en/book.mysqli.php|2|http://php.net/manual/en/function.mysql-connect.php^0|C|D|1J|D|22|9|0|2J|6|1|0|3|1F|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@$9|Y|A|Z|1|10]|$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|H|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]|P|$5|K|L|M|E|$N|Q]]|R|$5|K|L|M|E|$N|S]]]]

The <code>mysql_connect</code> function is deprecated as of PHP 5.5.0 and, as with most deprecated features, will be removed. Therefore, prefer using <a href="http://php.net/manual/en/ref.pdo-mysql.php" rel="nofollow">PDO_MySQL</a> (or another alternative <a href="http://php.net/manual/en/book.mysqli.php" rel="nofollow">MySQLi</a> ) over <code>mysql_connect</code>.

Source: <a href="http://php.net/manual/en/function.mysql-connect.php" rel="nofollow">http://php.net/manual/en/function.mysql-connect.php</a>

Should I use php PDO or normal mysql_connect to execute database queries in PHP?

Which one is faster?

One of the big benefits of PDO is that the interface is consistent across multiple databases.
There are some cool functions for prepared statements too, which take some of the hassle out of escaping all your query strings. The portability of PDO is greater than mysql_connect.

So, should I use PDO for those reasons or stick to the traditional mysql_connect?

PHP PDO vs normal mysql_connect

数据库

服务器

我应该使用PHP还是普通的mysql_connect在php中执行数据库查询？哪一个更快？PDO的最大好处之一是界面在多个数据库中是一致的。对于准备好的语句也有一些很酷的函数，可以省去转义所有查询字符串的一些麻烦。与mysql_connect相比，PDO具有更好的可移植性。那么，我是应该因为这些原因而使用PDO，还是应...

问PHP与普通mysql_connect
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP与普通mysql_connectEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP与普通mysql_connect
EN