MySQL Forums
Forum List  »  Views

Re: Join
Posted by: Peter Brawley
Date: April 15, 2013 03:29PM

After the EXPLAIN cmd that elicited it, issue:

show warnings;

I don't see anything about the table that might compromise the join count, so I'm left with the common observation that InnoDB count queries without Where clauses are notoriously slow. You could test that explanation by adding to the query a Where clauses that excludes a small proportion of hits.

Options: ReplyQuote


Subject
Views
Written By
Posted
5628
April 11, 2013 04:14PM
2356
April 11, 2013 11:41PM
2432
April 12, 2013 12:10AM
2332
April 12, 2013 10:21AM
2495
April 12, 2013 11:03AM
2347
April 15, 2013 01:05PM
2443
April 15, 2013 01:09PM
Re: Join
2653
April 15, 2013 03:29PM


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.