Using Proper Index. Using LIMIT using Primary KEy. Important : Wheneve

How can we optimize or increase the speed of a mysql select
query?

Question Posted / shanmuga

6 Answers
17064 Views
I also Faced
E-Mail Answers

Answer Posted / shanmuga

Using Proper Index.
Using LIMIT
using Primary KEy.

Important : Whenever the huge no of updation or deletion
happened in that table use OPTIMIZE TABLE command.This will
reduce the unused space.

Is This Answer Correct ?

16 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to call php function from javascript using ajax?

950

Can age be a variable?

893

What is local variable in php?

926

What is a helper function?

912

How do you connet mysql database with php?

1021

What is mvc in php?

973

How to remove duplicate values from array using php?

982

Why shouldn't I use mysql_* functions in php?

1022

How to convert a character to an ascii value?

1037

How does php work with apache?

995

What is the difference between unset and unlink?

929

What is php pathinfo?

1018

What is php and what does it do?

1014

When sessions ends?

914

Explain the three different kinds of Arrays?

1123