Roger, Friday, June 07, 2002, 12:43:38 PM, you wrote: RB> * Benjamin Pflugmann >> On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] 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 https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
