How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 16193 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / senthilkumar
1.Select <fieldname> from tablename.
2.Limit Setting.
3.Index Using
4.Primary key..
| Is This Answer Correct ? | 13 Yes | 1 No |
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 |
How do you parse and process html/xml in php?
How to redirect a page in php?
Why php language is used?
What is the use of preg_match in php?
Is it possible to submit a form with a dedicated button?
Tell me how is it possible to remove escape characters from a string?
What is difference between web service and api?
What are majic methords in php?
How error handling is being handled by php?
1.Where are the sessions storing ? 2.What are the contents of a session file ? 3.If the server is loaded with too many session files there is a possibility of server crash. How can we solve this issue? 4. How does php server identify that the particular session belongs to particular user ? For ex: If two users A and B logged from different machine, separate session files (say 1 and 2) will be created in the server. But how the php knows that 1 belongs to A and 2 belongs to B ?
What language is similar to php?
how can attached a file to a mail and attached a resume to a mail and received in id
PHP 
