Re: the IN list optimizer speed [Re: How can I disable equality propagation in MySQL 5.0]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Fri, 20 Jul 2007, Martin Friebe wrote:

> Part of the problem (at least where myisam is involved) is the way the
> optimizer calculates the cost.
>
> 2 older patches to gain about 20% in the myisam key lookup are
> http://bugs.mysql.com/bug.php?id=26232
> http://bugs.mysql.com/bug.php?id=26453
>
> This isn't enough of course. and I am looking fwrd to see how this may be
> solved. (Also the above affects myisam only)

Well, gaining 20% is not too shabby!

I notice that there has not been much activity on getting these patches incorporated since Martin posted them in February this year. Sergey, as you are the assignee for both of these: what's the status? Any plans on incorporating Martin's suggestions?

Bye,

        LenZ
- --
 Lenz Grimmer <lenz@mysql.com>, Community Relations Manager, EMEA  MySQL GmbH, http://www.mysql.de/, Radlkoferstr. 2, D-81373 München  Geschäftsführer: Kaj Arnö - HRB München 162140  http://forge.mysql.com/ | http://planetmysql.org/ | http://dev.mysql.com -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

iD8DBQFGpkgXSVDhKrJykfIRAu/WAJ9IdNjSZ8zIruexpiXT2FRsKS+3WQCfXybN m9SyPSK4qtINx9mOQtrU6Mk=
=ORBE
-----END PGP SIGNATURE-----

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com