Icy Phoenix

     
 

DB - How To Reduce SQL Charge On Server

DB - How To Reduce SQL Charge On Server

Article
Reply with quote    Download Post  
Post DB - How To Reduce SQL Charge On Server 
 
Hi all.

Icy Phoenix may be configured to be very fast, and to use a minimum charge of SQL.

I've created an ACP link for doing this quickly: ACP => Configuration => Quick Settings.

Remember that running one of that options 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_album_config) before running this file...

Remember also that these few suggestions may let you gain some extra speed on your Icy Phoenix.
  • 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, Site History and Referrers pages
  • Let only admins show user statistics on profile pages
  • In CMS use only the blocks you really need as global blocks
  • Reduce the number of Smileys
  • Reduce topics and posts per page
  • Disable UPI2DB, or enable it only for admin and moderators
  • Don't use acronyms, autolinks, censor
  • Enable LoFi for Bots
  • Disable Online users on forum index
  • Enable posts cache (pay attention on multilanguage forums)


Use this topic in conjunction with this one to optimize your site:
How To Reduce CPU Charge On Server

P.S.: while running this file you may be warned by some errors in updating config... this may depends on the version of your package, please, do not pay attention to the output log, and in any case you can restore your backup if you have problems.



 
Edited by Mighty Gorgon, Sat 10 Nov, 2007 19:57: Tips updated
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sun 08 Apr, 2007 11:47 ]
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us


DB - How To Reduce SQL Charge On Server

Comments
Reply with quote    Download Post  
Post Re: How To Reduce SQL Charge On Server 
 
Added some other tips.



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sat 10 Nov, 2007 20:00 ]
Display posts from previous:    

HideWas this topic useful?

Post new topic  Reply to topic  Page 1 of 1