List:General Discussion« Previous MessageNext Message »
From:Sabine Richter Date:June 5 2002 5:27pm
Subject:Re: Maximum JOINED tables
View as plain text  
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:roger.baklund@stripped]
> 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 <mysql-thread111069@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-wweaver=rightnow.com@stripped>
> 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 <mysql-thread111073@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-sabine=textraeume.de@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
Maximum JOINED tablesArthur Fuller5 Jun
  • Re: Maximum JOINED tablesRoger Baklund5 Jun
RE: Maximum JOINED tablesWalt Weaver5 Jun
  • RE: Maximum JOINED tablesAndrew Hazen5 Jun
RE: Maximum JOINED tablesWalt Weaver5 Jun
RE: Maximum JOINED tablesWalt Weaver5 Jun
  • Re: Maximum JOINED tablesSabine Richter5 Jun
    • Re: Maximum JOINED tablesDan Nelson5 Jun
  • Re: Maximum JOINED tablesRoger Baklund5 Jun
    • Re: Maximum JOINED tablesHarald Fuchs6 Jun
      • RE: Maximum JOINED tablesRoger Baklund6 Jun
        • Re: RE: Maximum JOINED tablesVictoria Reznichenko6 Jun
          • Re: Maximum JOINED tablesRoger Baklund6 Jun
            • Re: Maximum JOINED tablesBenjamin Pflugmann7 Jun
              • Re: Maximum JOINED tablesRoger Baklund7 Jun
                • Re: Re: Maximum JOINED tablesVictoria Reznichenko7 Jun
                  • Re: Maximum JOINED tablesRoger Baklund7 Jun
                • Re: Maximum JOINED tablesBenjamin Pflugmann7 Jun
                  • Re: Maximum JOINED tablesRoger Baklund8 Jun
                    • Not using indexes???Jon Frisby8 Jun
                      • Re: Not using indexes???Erv Young8 Jun
                      • Re: Not using indexes???bvyas38 Jun
                        • RE: Not using indexes???Jon Frisby8 Jun
                          • Re: Not using indexes???Benjamin Pflugmann8 Jun
                            • Re: Not using indexes???Erv Young10 Jun
                            • RE: Not using indexes???Jon Frisby10 Jun
                              • php+mysql+multiple lines qrycristian ditoiu10 Jun
                                • Re: php+mysql+multiple lines qryBrent Baisley10 Jun
                                  • Re: php+mysql+multiple lines qrycristian ditoiu10 Jun