* Victoria Reznichenko > RB> mysql is considered to be platform independant, and I suppose > RB> MySQL AB is trying to keep it that way...? > > Roger, MySQL is platform independent.
I did not say it was not... :) > 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. If the feature set is different on different platforms, the product is not truly platform independant. The number of joins in a query is a part of the feature set, IMHO. It is fully possible that right now someone is developing an application on a 64bit platform, not knowing that the system will not work on 32bit platforms simply because they have too many joins. It is not the 'lack of power' on 32bit platforms that will prevent it from working, it's the _platform dependant_ limitation in the number of joins. Ok, _now_ I am saying that mysql is not platform independant, but of course, this 'incompatibility' is not something most users will run into, so I guess we could say it is 99% true that mysql is platform independant, or that mysql is 99% platform independant... :) (There are also issues with letter casing in table names and different implementations of the floating point methods.) > 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. And in this case 'slower' means...? (If we are talking about milliseconds per query, I don't see the problem. If we are talking about milliseconds per traversed row, there would be a problem.) Has anyone ever done this hack, and if so, was the result usefull? Thank you for the info, Victoria! :) ...and sorry to those who got fooled by me pointing at crashme telling them the limit was 64 in 3.23.x... -- Roger sql --------------------------------------------------------------------- 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
