简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

PHP5.3. and PHP5.4. 在Windows环境下连接Mysql效率慢解决方案

WBOY
Release： 2016-06-13 10:27:24
Original
882 people have browsed it

PHP5.3.* and PHP5.4.* 在Windows环境下连接Mysql效率慢
如题，经过判断，我认为是VC9编译的问题，VC6编译的PHP5.2.17就很快，同样的一个简单查询，VC6的PHP5.2.17用了6豪秒多，而高版本的VC9编译的5.3和5.4却用了两秒多。足以证明VC9编译的PHP在Apache下工作有问题。
我下了VC9编译的Apache2，也是不行的。
求高手，有解决办法么

------解决方案--------------------
我也遇到了执行效率问题，经测试和排查跟编译版本和mysqlnd无关，其实解决方法很简单，如下：

将连接数据库语句中的“ $dbhost=‘localhost’ ”
改为“ $dbhost = '127.0.0.1' ”

这是因为“localhost”同时存在于IPv6和IPv4中造成冲突所致。
------解决方案--------------------

探讨

我也遇到了执行效率问题，经测试和排查跟编译版本和mysqlnd无关，其实解决方法很简单，如下：

将连接数据库语句中的“ $dbhost=‘localhost’ ”
改为“ $dbhost = '127.0.0.1' ”

这是因为“localhost”同时存在于IPv6和IPv4中造成冲突所致。
Related labels：
localhost php
source：php.cn
Previous article：奇怪的乱码有关问题，大家！ Next article：PHP插入SQL中文乱码！解决方案
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
Latest Issues
How to fix the problem: "Unable to load resource: net::ERR_CONNECTION_REFUSED http://localhost:8989/route?...." There is a problem with my program. This is a program about geographic information systems...
From 2023-11-12 19:34:27
0
1
244
Root user is denied access to MySQL I recently installed MySQL on x86_64 Access denied for "localhost" (using passwo...
From 2023-11-09 11:00:45
0
1
204
Vite-proxy node v17+ encounters ECONNREFUSED error I'm using Nodev18.12.1 and vitev3.0.4. Below is my proxy code to connect to Node.jsRESTAPI...
From 2023-11-07 20:00:40
0
1
262
How to prevent the page from scrolling after route changes in Nuxt? I have a Nuxt project. When I change the route from http://localhost:3000/catalog/postery ...
From 2023-11-06 18:56:58
0
1
266
Vue, vite: GET http://localhost:3000/@vite/client The title of net::ERR_ABORTED 404 (Not Found) is rewritten to: Vue, vite: on http://localhost:3000/@vite/client A net::ERR_ABORTED 404 (not found) error occurred in the initiated GET request. I'm using Vue and vite to practice the workflow of a web application that uses an API to g...
From 2023-11-06 11:49:11
0
2
255
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！