Re: slow mysql response
Have you got indexes on all the join columns and the order_date column?
You might want to add the time onto your query as well (00:00:00 in the first case and 23:59:59 in the 2nd case) - not sure you query will be looking at all the data, either that or specify the next day (ie. 2005-09-01 to 2005-10-01. Just a thought. Be worth checking to make sure you are getting the correct results.
Subject
Views
Written By
Posted
2706
September 29, 2005 06:46PM
Re: slow mysql response
1404
September 30, 2005 02:29AM
1331
September 30, 2005 06:34AM
1302
September 30, 2005 12:00PM
1234
September 30, 2005 12:59PM
1317
September 30, 2005 03:26PM
1446
September 30, 2005 03:40PM
1299
September 30, 2005 02:28PM
1284
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.