MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: high cpu on request with JOIN
Posted by: Øystein Grøvlen
Date: January 15, 2016 05:43AM

Hi,

In order to be able to give good advice on improving query performance, we need to know more about the tables involved. (The output of SHOW CREATE TABLE for both tables would be useful.) However, assuming that iViewConferenceId is a column of the meeting table, I would guess what is needed is to create an index on this column.

Regards,

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
high cpu on request with JOIN
1538
Gérard Moisset
January 15, 2016 03:49AM
Re: high cpu on request with JOIN
761
Øystein Grøvlen
January 15, 2016 05:43AM


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.