Jump to content

How to lower server load due to PHP


ksduded

Recommended Posts

I am expecting a lot of traffic over the weekend only due to a massive campaign. I have a mysql database with 4 databases of average 800 Kib each. At a given php page... around 30 records are shown with 13 fields each. Basically its a calender of shows for a particular month. I also have a search function which parses the whole table for searched string.....

 

I am thinking of making the search function temporarily unavailable so that I can reduce the load. Is there any another methods which can help?

Link to comment
https://forums.phpfreaks.com/topic/153378-how-to-lower-server-load-due-to-php/
Share on other sites

You might take a look at your database queries: I find it quite common for developers to make several individual queries when they could retrieve the data with a single, more complex query (perhaps using joins), or a query in a loop so it is issued several times when it could just be issued once.

 

Additionally, check indexes on tables, or look at full text searches in MySQL, depending on the actual queries that are being executed

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.