And how long does it take to compile a 32-tables-statement? With the gupta server a 14-tables-statement took 2 hours.
Sabine "Weaver, Walt" wrote: > > Hmmm... we're running 3.23.47 here and have run into a 32 table join > limit... > > --Walt > > -----Original Message----- > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 05, 2002 10:19 AM > To: mysql mailing list > Cc: Arthur Fuller > Subject: Re: Maximum JOINED tables > > * 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. > > <URL: http://www.mysql.com/information/crash-me.php > > > -- > Roger > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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