Hi.
On Wed, Feb 07, 2001 at 09:39:15AM -0500, [EMAIL PROTECTED] wrote:
> Yes, I should have been more clear, I know that you can join a table to itself but I
>am trying to find out:
>
> 1) What is the max number of joins (unique tables/mixture of same table joins)
As far as I remember, there is no direkt limit, only indirect ones:
e.g. table_cache must be big enough, the optimizer uses an algorithm
which won't be useful above 20-30 tables (your milleage may vary - AND
you can circumvent by using STRAIGHT_JOIN) and so on.
> 2) What is the max number of same-table joins
I assume the same as above.
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
