-----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@stripped>, 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/
iD8DBQFGpkgXSVDhKrJykfIRAu/WAJ9IdNjSZ8zIruexpiXT2FRsKS+3WQCfXybN
m9SyPSK4qtINx9mOQtrU6Mk=
=ORBE
-----END PGP SIGNATURE-----