Optimizing the performance of Question2Answer
Question2Answer is built to run quickly and efficiently on your web and database servers. Nonetheless, if your Q2A site starts receiving a lot of traffic, you may wish to consider these additional steps to help it operate at maximum speed:
-
Switch on the query cache in your MySQL server. This allows MySQL to store the results of Question2Answer's queries, instead of recalculating them each time. It is especially relevant if your site receives a lot more views than edits. Note this MySQL feature has been removed in MySQL 8.
-
Upgrade to the latest version of PHP. Newer versions contain many performance enhancements, in particular PHP 7 which is up to twice as fast as PHP 5.6.
-
If you are on PHP 5.4 or below, install a PHP accelerator such as Opcache or Alternative PHP Cache (APC). This will cache the compiled bytecode for the Question2Answer PHP scripts on your web server, to avoid them being parsed and compiled for each page request. PHP 5.5 and later are bundled with Opcache by default.
-
Question2Answer is engineered to minimize the number of MySQL queries used per page. This allows you to separate your database and web servers without suffering too much from latency. The downside is that the resulting queries can be quite complex. If your database and web servers are running on the same box, latency is not an issue, so set
QA_OPTIMIZE_LOCAL_DB
totrue
andQA_OPTIMIZE_DISTANT_DB
tofalse
inqa-config.php
. This will uses many simple MySQL queries instead of fewer complex ones. -
Check the other settings and accompanying comments at the end of
qa-config.php
.