MySQL Forums
Forum List  »  Newbie

query runs much slower if used as subquery, is it normal?
Posted by: Massimiliano Balestrini
Date: October 20, 2008 07:16AM

Hello,
first post here for me.
I have a query that runs in about 0,3 seconds. Let's call it just query.

select "query" runs in 0,3 seconds.

if I do select * from (select "query") it runs in 3 to 4 seconds...

I'm aware that there is one more layer for Mysql to manage, but 10 times slower?
Is it normal? I looked around but did not find information about this. So I posted it here because i'm not sure if it's a problem at all.

Thank you

Max

Options: ReplyQuote


Subject
Written By
Posted
query runs much slower if used as subquery, is it normal?
October 20, 2008 07:16AM


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.