-----BEGIN PGP SIGNED MESSAGE-----
On Thu, 22 Jul 2004, Christian Hammers wrote:
> I've just got the hint to build my packages with this option.
> Looks good (enabling ~64 instead of ~32 tables in a join) but
> I wonder why it isn't the default. Are there major performance
Here is a reply I got:
On 32-bit systems both BIG_JOINS and BIG_TABLES end up using 64-bit
integers instead of 32-bit ones.
That makes things slower.
How much ???
Depends on the queries ... 5 % ??
So it's hard to tell - we have not yet benchmarked these two
configurations against each other. It may make sense to enable this option
for the "Max" binary only (as we do it) - if you have a "max" binary at
all, that is.
Lenz Grimmer <lenz@stripped>
Senior Production Engineer
MySQL GmbH, http://www.mysql.de/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/
-----END PGP SIGNATURE-----