optimising queries

Forum Moderators: open

Message Too Old, No Replies

optimising queries

I need to optimise queries

IsItUPYet

9:56 am on Dec 7, 2006 (gmt 0)

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

11:52 am on Dec 7, 2006 (gmt 0)

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

11:45 pm on Dec 7, 2006 (gmt 0)

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?