ksduded Posted April 9, 2009 Share Posted April 9, 2009 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 More sharing options...
Axeia Posted April 9, 2009 Share Posted April 9, 2009 Take a look at this site: http://www.addedbytes.com/php/caching-output-in-php/ I doubt it's something you'd want to implement on a atm heavily visited site in a rush though.. and for a search function it would do you no good. Link to comment https://forums.phpfreaks.com/topic/153378-how-to-lower-server-load-due-to-php/#findComment-805810 Share on other sites More sharing options...
Mark Baker Posted April 10, 2009 Share Posted April 10, 2009 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 Link to comment https://forums.phpfreaks.com/topic/153378-how-to-lower-server-load-due-to-php/#findComment-806218 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.