MySQL Forums
Forum List  »  PHP

Re: Time-out problem
Posted by: Peter Brawley
Date: April 30, 2014 01:12PM

A starting rule of thumb for such queries is have covering indexes on Join, Group By and Where columns in that order:

spd_unit (fk_id,fk_id_ad_format,fk_campaign_id,spd_unit_duration_time)
spd_ad (id_ad)

Options: ReplyQuote


Subject
Written By
Posted
April 23, 2014 08:04AM
April 23, 2014 09:57AM
April 23, 2014 10:27AM
April 25, 2014 02:26PM
April 28, 2014 11:49AM
April 30, 2014 11:15AM
April 30, 2014 11:32AM
April 30, 2014 11:47AM
May 01, 2014 08:00AM
Re: Time-out problem
April 30, 2014 01:12PM
May 02, 2014 10:40AM
June 06, 2014 05:13AM
June 06, 2014 09:15AM


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.