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.
Showing posts with label How can increase the performance of MySQL select query?. Show all posts
Showing posts with label How can increase the performance of MySQL select query?. Show all posts
Saturday, May 16, 2009
Subscribe to:
Posts (Atom)
