optimising queries

I need to optimise queries

[IsItUPYet]

Hi i currently manage a website and the main issue at the moment is the speed of certain pages.

I wish to optimize the queries but don't know where to start?

any ideas

I thought of caching also but i'm unsure about this aswell

[eelixduppy]

Related Thread [webmasterworld.com]

Also check Optimization Documentation [dev.mysql.com] (hey, it rhymes ;))

Good luck!

[edited by: jatar_k at 11:31 pm (utc) on Dec. 7, 2006]

[phranque]

you should first do some type of instrumentation to determine where the bottlenecks are and concentrate your resources where you will get the biggest result.
a 25% improvement to 50% of the process is better than a 90% improvement to 1% of the process.
is your problem in the server? db? script?