jug Posted December 9, 2009 Share Posted December 9, 2009 Hi, I am interested about making queries and code more efficient to put less strain on the server. I know of a few possibilities i could use and would just like your thoughts on them really. I am using mysqli. 1) prepare statements - i understand how they work but wander if it will really make a big difference 2) closing $result (record sets) after they have been used with $result->close(); 3) indexes on table rows Also i wandered if there was any way or application that measures server load / time taken to execute queries / logs all queries executed on any web page so i could see how much these things do affect the efficiency. Any help would be much appreciated. Thanks in advance. jug Link to comment https://forums.phpfreaks.com/topic/184519-database-and-query-efficiency/ Share on other sites More sharing options...
JustLikeIcarus Posted December 9, 2009 Share Posted December 9, 2009 Take a look at this article http://forge.mysql.com/wiki/Top10SQLPerformanceTips Link to comment https://forums.phpfreaks.com/topic/184519-database-and-query-efficiency/#findComment-974139 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.