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
- 17472 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 |
What is the use of mysql_fetch_array in php?
How do I stop a php script?
What is php simple definition?
Specify array sort functions available in php ?
hi here one small project given to me in an software company during interview. one page that would count down till 9pm (today means every day before 9pm it would count down to zero) this means there will show how many mins. sec. and hours are left till 9pm so it would be like 1 hr 20 mins 23 sec. then it up count down every sec and then show 1hr 20mins 22sec left till 9pm once the count down reaches zero it would show a flesh player video will autostart. the flash player will be from http://www.longtailvideo.com/players/jw-flv-player/ (the player is embed into the page.) that same page will track to see if they have already seen the video using php sessions then if they go back to that page it would redirect them to a new page saying that they have already wathed the video.
Does php 7 support mysql?
What is the difference between html and php?
Explain the installation of PHP on UNIX systems?
what is the use of include_once in php?
What are the benefits of using php and mysql?
How to protect special characters in query string?
What are the differences between PHP3 and PHP4 and PHP5? what is the current stable version of PHP?
PHP 
