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

Categories >> Software >> Programming Languages >> PHP Related >> PHP
Suggest New Category

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

Question Posted / phpwizz

6 Answers
17005 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / nikunj

For increase speed of select query, there are some factor
like...
-By using Limit in query
-By using Index on table
-By using Primary key

Is This Answer Correct ?

17 Yes

5 No

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

Answer / senthilkumar

1.Select <fieldname> from tablename.
2.Limit Setting.
3.Index Using
4.Primary key..

Is This Answer Correct ?

13 Yes

1 No

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

Answer / umapathi

using limit option

Is This Answer Correct ?

17 Yes

7 No

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

Answer / md raisul azam

Limit
Indexing
key

Is This Answer Correct ?

4 Yes

2 No

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

Answer / david

You can optimize sql queries using dbForge Studio for MySQL:
1. Open a query file -> click the Query Profiling Mode button on the SQL toolbar -> the Query Profiler tool.
2. Execute the query by clicking the Execute button or F5. The Profiler document view opens. See the query profiling results displayed on three tabs - Profile, Plan and Status.
3. After you have made changes in the query, click the Get New Results button in the Profiler document view. New profiling results appear in the tree view as a new node with time and date of query execution. You can easily distinguish and navigate to them.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer