Basic PHP Programming Question:

How can increase the performance of MySQL select query?

Tweet Share WhatsApp

Answer:

We can use LIMIT to stop MySql for further search in table after we have received our required no. of records, also we can use LEFT JOIN or RIGHT JOIN instead of full join in cases we have related data in two or more tables.

Download PHP PDF Read All 139 PHP Questions
Previous QuestionNext Question
What type of inheritance that php supports?How can I use the COM components in php?