How To Reduce SQL Charge On Server


Subject: 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:
  • 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!)


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...

Remember also that these few suggestions may let you gain some other speed on your phpBB XS.
  • 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.


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:


quick_xs_settings.zip
Description: XS Quick Settings 
Download
Filename: quick_xs_settings.zip
Filesize: 2.68 KB
Downloaded: 718 Time(s)

Subject: Re: How To Reduce SQL Charge On Server
great work :mrorange:

Subject: Re: How To Reduce SQL Charge On Server
hmm..

what kind of settings does it change?

I don't feel like figuring out what settings I had and stuff :mrgreen:
if it's something I didn't really configure I'll give that thingy a go :mrg:

Subject: Re: How To Reduce SQL Charge On Server
This script sets some features to OFF, so you are able to save SQL charge to your server... try it, and let me know! :wink:

Another thing that may save you bandwith (not SQL), may be using the new style Aphrodite Text, which is included in the latest XS. This theme is really light, and could speed up page loading for mobile devices with slow connections. My advice is to set this template as the default one.

Subject: Re: How To Reduce SQL Charge On Server
Mobile devices are great with the lo-fi... I use it a lot!
Today I'll try Aph Text.

Subject: Re: How To Reduce SQL Charge On Server
i uploaded the script but how do i run it.

Subject: Re: How To Reduce SQL Charge On Server
oscarxp wrote: [View Post]
i uploaded the script but how do i run it.


Simply type in address bar "http://www.domain.ext/script_name.php"...


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.1649s (PHP: 12% SQL: 88%)
SQL queries: 15 - Debug Off - GZIP Enabled