How can we optimize or increase the speed of a mysql select
query?
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
What is the meaning of a persistent cookie?
Tell me what is pear?
Which cryptographic functions in php returns the longest hash value?
Tell me what does $_env means?
How to get ip address of clients machine?
How to add comments in php?
Which method do you follow to get a record from a million records? (Searching not from database, from an array in php)?
Which methods should be used for sending an email using the variables $to, $subject, and $body?
How to read and display a HTML source from the website url?
What is difference between isset and empty in php?
How check variable is set or not in php?
Why should I store logs in a database rather than a file?
What is composer used for?
What are the differences between GET and POST methods in form submitting?
What is mysql_fetch_row?