MySQL Forums
Forum List  »  Newbie

Re: Very slow query, and, and, and...
Posted by: Gerrit Andresen
Date: January 06, 2015 05:11AM

Hi Peter,

thanks for your help. I take a look on joins (better i have to do) and optimize my queries a lot. Maybe this kind of queries is much to complex to use only "and(s)".


Hi Rick,

The optimizer_search_depth made it far more faster... but i dont know what this parameter sets up. I go now down to 0.002 seconds instead of nearly 3.000

WOW. But my query is still a weak one i think.

But thanks a lot you two.

Gerrit

Options: ReplyQuote


Subject
Written By
Posted
Re: Very slow query, and, and, and...
January 06, 2015 05:11AM


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.