This is a discussion on reducing the query execution time within the Database Support forums, part of the Web Development category; Hi, wat are the ways to tune the MySQL query to retrive the data in fast... in millions of record.....
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Hi, wat are the ways to tune the MySQL query to retrive the data in fast... in millions of record.. |
|
#2
| |||
| |||
| Hi, Here, 1.Mainly build index for a table,index concept is used to reduce or optimize(minimize) the query execuetion time. 2.Follow the de-normalization. The above two points are known in my level. Thanks, Prasath.K |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reducing size of .ndf file in Ms Sql 2005 | nnraja | Database Support | 7 | 05-14-2009 04:07 AM |
| How can we increase the execution time of a php script? | sundarraja | PHP Programming | 0 | 02-01-2008 09:50 PM |
| What is an Execution Plan ? | vadivelanshanmugam | Database Support | 0 | 01-23-2008 06:06 AM |
| How can we increase the execution time of a php script? | Sabari | PHP Programming | 3 | 09-26-2007 08:23 AM |
| Determine execution time in PHP | bluesky | PHP Programming | 1 | 07-21-2007 12:40 AM |
Our Partners |