MySQL Forums
Forum List  »  Newbie

query size
Posted by: Marco Bormann
Date: February 26, 2009 07:13AM

Since I never - until now - worked with real huge tables I have a question on the size of a query. My query would have a maximum result of 600000 lines, but since I might have up to 11 tables in the FROM tag, the cartesian product of which will come easiely up to 10^27.
Is such a query in MySQL possible or will it slow everything down or even blow the server away? What would be a reasonable limit for the cartesian product in the FROM tag?

Options: ReplyQuote

Written By
query size
February 26, 2009 07:13AM
February 26, 2009 07:27AM
February 26, 2009 07:29AM
February 26, 2009 08:41PM

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.