How can we optimize or increase the speed of a mysql select
query?
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 |
Why php is also called as scripting language?
what are in image creating functions in php
Want to know the 10th max salary in salary table
sort term descripttion form, report and uery
What is php sequence?
Actually am working in existing project which is developed in .net, am converting the .net into php code. am facing problem after uploading the .php in server. amgetting the error message like "The page cannot be found" but its working perfectly in local host
How variables are passed through arguments?
•How to access crystal reports through PHP code?
is php is the best for this situation
How the web server interprets php and interacts with the client?
What is the use of mysql_real_escape_string() function?
Is php a cms?