• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • Last Modified:

PHP Application Running Really slow


I have an invoicing PHP application running on a Rackspace Could server which has WHM/Cpanel installed. The application has been running fine until I used EasyApache the other day to re-compile apache and install MySQLi. Since doing that, this particular application runs really slow and renders slowly on the page.

This application was developed using mysql_query(), since changing it to use MySQLi the performance has returned to normal.

My question is, what is causing the slow down when using mysql? I'm guessing it's because in the background there are depreciation errors being generated and logged in the background? but I've setup php.ini not to display them.

Is there any way to stop this from happening as there may also be old applications on the server which are yet to be updated?
1 Solution
That's definitely possible. If you are logging warnings to a file, then I'd check the size of your log file. If it's huge and filled with mysql warnings, then that's probably your culprit. Hard disks / filesystems are always the slowest I/O components in the entire web serving process, so if you're having PHP write to a file a LOT, then you will definitely have some performance issues.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now