Re: slow mysql response
uzwa ulhaque wrote:
> I am executing following query which returns a summary reports for the monthly sales of a local
> resturant, this query is taking up aroung 7 minutes:
> any ideas on how to optimize it :-S
Please post the output of
EXPLAIN SELECT ... \G
as well as the output of
SHOW INDEX FROM table \G
for each table involved in the query.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
2697
September 29, 2005 06:46PM
1402
September 30, 2005 02:29AM
Re: slow mysql response
1329
September 30, 2005 06:34AM
1301
September 30, 2005 12:00PM
1232
September 30, 2005 12:59PM
1316
September 30, 2005 03:26PM
1444
September 30, 2005 03:40PM
1296
September 30, 2005 02:28PM
1283
September 30, 2005 04:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.