Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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.

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

 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: How To Reduce SQL Charge On Server 
 
great work
 




____________
jack of all trades, master of none
http://www.mieloma.com/ - http://www.casimedicos.com/ - http://www.egalego.com/ - http://www.casimedicos.com.es/ - http://www.medicosmir.com/
 
casimedicosSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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  
if it's something I didn't really configure I'll give that thingy a go
 




____________
check out my site sometime
www.Dutch-HQ.net
 
NizzleSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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!

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.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 




____________
Megabass
 
ganeshSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: How To Reduce SQL Charge On Server 
 
i uploaded the script but how do i run it.
 



 
oscarxpSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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"...
 




____________
~~~ Andrea ~~~
User #379756 on Linux Counter
"If you can't apt-get something, it isn't useful or doesn't exist!!"
 
buldoSend private messageVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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


  

 

  cron