In the last episode (Jun 05), Sabine Richter said:
> "Weaver, Walt" wrote:
> > From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> > * Arthur Fuller
> > > I have searched the manual without success. I want to know the
> > > maximum number of tables MySQL permits to be JOINed in a single
> > > SELECT statement.
> >
> > According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39.
> >
> > Hmmm... we're running 3.23.47 here and have run into a 32 table
> > join limit...
>
> And how long does it take to compile a 32-tables-statement? With the
> gupta server a 14-tables-statement took 2 hours.
That all depends on how complex your query is and the size of the
tables. A query that takes 2 hours to run probably can be optimized a
lot, though.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
