Interested to Buy Any Domain ? << Click Here >> for more details...
How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 17272 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Tell me what sized websites have you worked on in the past?
Is php a programming language?
Which function is used to strip whitespace?
How do I sort numbers in php?
How escape single quotes php?
Why should I learn php?
How do you pass a variable by value?
What is advanced php programming?
What is rtrim php?
What is difference between single quotes and double quotes in php?
Is key in array php?
Is php harder than javascript?
How check field is empty or not in php?
Tell me which function gives us the number of affected entries by a query?
How we get ip address of client, previous reference page etc?
