List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:June 7 2002 4:07pm
Subject:Re: Re: Maximum JOINED tables
View as plain text  
Friday, June 07, 2002, 12:43:38 PM, you wrote:

RB> * Benjamin Pflugmann
>> On Thu 2002-06-06 at 19:17:10 +0200, roger.baklund@stripped wrote:
>> [...]
>> > But... is this the only feature of mysql which is dependant on the
>> > processor architecture?
>> See it the other way: You are not garantueed more than 31 tables in a
>> join. If you happen to have a 64Bit architecture, you can use more.

RB> Yes... a positive attitude makes life easier. :)

RB> However, I think my question is valid... I don't think it is a good idea to
RB> limit the number of joins based on the processor architecture, and this
RB> makes me wonder what other 'strange' limitations I might find in mysql...
RB> some questions to Victoria/MySQL AB:

RB> mysql is considered to be platform independant, and I suppose MySQL AB is
RB> trying to keep it that way...?

Roger, MySQL is platform independent. It works on any platform with
the same data, but if the architecture is 64 bit, you can use it for more
power than on 32 bit.

RB> Will the max number of joined tables (on 32-bit platform) stay at 31 in
RB> version 4.x, or is it planned to increase this limit?

I don't know.

RB> Is this limitation "by design", and if so, why? (I suspect it is by
RB> accident, and that's ok. That would mean it will probably be fixed in the
RB> future.)

You can change it (set 63) in 32 bit CPU by hack in compilation, but
making join map 64 bit on 32 bit box makes the work of MySQL slower.

For technical support contracts, goto
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

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