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
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 https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net