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

Hi Christian,

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?

I guess there is some kind of performance penalty - however I can't tell
for sure if it's big. I have forwarded your question to our developers -
let's see what they have to say about that.

Another option that might be worth enabling is "-DBIG_TABLES" - that
enables you to use much more rows in a table. However, it too increases
some internal structures and thus requires more memory. We only enable it 
for our "Max" binaries.

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/

iD8DBQFBAE7PSVDhKrJykfIRAlLqAKCATOn8XOqlin/iDOTppMv2cznJVQCeIuTZ
dZN1v1EegSD9NSutkv76O1A=
=BTxy
-----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