IT Community - Software Programming, Web Development and Technical Support

reducing the query execution time

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.....


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 07-19-2007, 06:38 AM
kathir kathir is offline
D-Web Trainee
 
Join Date: Feb 2007
Posts: 13
kathir is on a distinguished road
Default reducing the query execution time

Hi,

wat are the ways to tune the MySQL query to retrive the data in fast... in millions of record..
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 07-19-2007, 09:55 PM
prasath prasath is offline
D-Web Sr.Programmer
 
Join Date: Jul 2007
Location: Chennai
Posts: 173
prasath is on a distinguished road
Post Re: reducing the query execution time

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
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

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


All times are GMT -7. The time now is 10:56 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0