List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:June 6 2002 5:17pm
Subject:Re: Maximum JOINED tables
View as plain text  
* Victoria Reznichenko
[...]
> RB> So... is the crashme report wrong? Or was the limit really 32
> RB> in 3.22.39, got lowered to 31 in later versions (like 3.23.30-
> RB> gamma), raised to 63 in version 3.23.39, and then lowered to
> RB> 31 again (at least in versions 3.23.47 and 4.0.1)...?
>
> RB> <URL: http://www.mysql.com/crashme >
>
> RB> (Select both mysql versions, submit, and search for "tables
> RB> in join" on the result page.)
>
> If you have 32 bit CPU you can use 31 tables in join. 63 tables with
> 64 bit CPU.

ok... thanks.  :)

But... is this the only feature of mysql which is dependant on the processor
architecture?

I'm kind of nervous about this, because I'm currently working on a 'very
normalized' database schema, and it is possible I will need more than 31
tables in a single select... including multiple joins to the same tables, of
course. It would be very bad if my design turned out to be 64-bit
dependant...

--
Roger

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