s9e\reckless is an experimental phpBB 3.3 extension that aims to improve the performance of an average-to-big forum through the use of additional indexes, MySQL hints, query rewrites and dark magic.
Download the latest release and unzip in the phpBB/ext directory of your forum. Then go to the ACP and enable the extension. The installation may take several minutes depending on the number of posts and topics.