Re: slow mysql response
Instead of the composite index in the Detail_Table, I would try with 4 single column indexes on
category_id, Category_detail_id, Customer_id and user_id.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
2706
September 29, 2005 06:46PM
1405
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
Re: slow mysql response
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.