https://www.icyphoenix.com/viewtopic.php?f=30&t=75&p=471#p471
-----------------------------------
Mighty Gorgon
Tue 15 Aug, 2006 12:51

How To Reduce SQL Charge On Server
-----------------------------------
Hi all.

phpBB XS may be configured to be very fast, and to use a minimum charge of SQL.

I've created a file for doing this quickly.

How to use this file:
[list][*]Download this file
[*]Upload it in your phpBB XS root folder
[*]Login as Admin
[*]Run this file
[*]Choose your option
[*]Enter the ACP when you have finished (just to make sure that che CACHE of config tables is emptied!)
[/list]

[color=crimson]Remember that using this file your configuration settings will be changed, and if you have set some specific parameter then you may have to setup it again!!! You should make a full backup of your CONFIGs tables (phpbb_config, phpbb_config_mg, phpbb_album_config) before running this file...[/color]

Remember also that these few suggestions may let you gain some other speed on your phpBB XS.
[list][*]Disable Thanks Topic
[*]Disable Topics Ratings
[*]Disable Topics Notifications
[*]Disable Access to pages you're not using (this could save you enormous resources)
[*]Disable Statistics page
[*]In Portal use only the blocks you really need and CACHE all blocks that could be CACHED... such as text only blocks or rarely updated blocks.[/list]

P.S.: this file includes some vars you may not have on your XS, because it's based on new XS release... so, don't pay attention to some errors you may have in executing this. :wink:


