MYSQL Query optimize and load faster - Post.Byes

X

zabsmarty

New Member

Join Date: Feb 2007

Posts: 25
#1

MYSQL Query optimize and load faster

Oct 16 '08, 10:11 AM

Can any one help me to make my query code optimize and load faster.
Please help me or any example what steps should we use to optimize.
Thank You
Tags: None
mwasif

Recognized Expert Contributor

Join Date: Jul 2006

Posts: 802
#2

Oct 16 '08, 10:24 AM

Properly index your tables. Use EXPLAIN to the execution plan of your query. Also look at this.
Comment
zabsmarty

New Member

Join Date: Feb 2007

Posts: 25
#3

Oct 18 '08, 09:09 AM

Thanks for replying me.
Comment
mwasif

Recognized Expert Contributor

Join Date: Jul 2006

Posts: 802
#4

Oct 19 '08, 05:42 AM

You are welcome!
Comment

Previous template Next

Working...