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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/184519-database-and-query-efficiency/#findComment-974139 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.