List:Packagers« Previous MessageNext Message »
From:Lenz Grimmer Date:July 27 2004 8:22am
Subject:Re: -DBIG_JOINS
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

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 
> drawbacks?

Here is a reply I got:

[SNIP]
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 % ??
[SNIP]

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.

Bye,
	LenZ
- -- 
 Lenz Grimmer <lenz@stripped>
 Senior Production Engineer
 MySQL GmbH, http://www.mysql.de/
 Hamburg, Germany
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQFBBhC2SVDhKrJykfIRAolJAJ0Ukw8wsQJM+3jwOvg6YfF3HZJSJwCeKOyc
9x9+HCgdV7NTLEUt1HkazKU=
=JuRK
-----END PGP SIGNATURE-----
Thread
-DBIG_JOINSChristian Hammers22 Jul
  • Re: -DBIG_JOINSLenz Grimmer23 Jul
    • Re: -DBIG_JOINSChristian Hammers23 Jul
      • Re: -DBIG_JOINSLenz Grimmer27 Jul
  • Re: -DBIG_JOINSLenz Grimmer27 Jul