Re: core dump in mysql_bind_param (versions 4.1.1-alpha, 5.0.0-al pha, 4.1.2-alpha-nightly)

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

Kevin,

> Why are pre-compiled queries 50% slower to execute than parsed
> queries?

> Based on the following
> "INSERT INTO ssa_keys(urn,key_address,addr_part1,addr_part2,postcode)
>  Values(1,'8charstr','Part 1 of an address','part 2 of an
> address','postcode')"
> and
> "INSERT INTO ssa_keys
> (urn,key_address,addr_part1,addr_part2,postcode) Values(?,?,?,?,?)"
> and inserting 24000 rows
>
> The parsed query executes in 7 secs with a mean insert time of 277uS
> whilst the compiled query (just the execute time - not including the
> prepare/bind times) executes in 12 secs with a mean insert time of
> 455uS.

Are you seeing this against a recent snapshot of 4.1.2?  There were some
issues in earlier versions that would have caused this, but these should
be corrected now.

I will run some tests against the current sources, but of course this
type of performance anomaly should not be occuring.

Best regards,
- --
Dean Ellis, Support Engineer & Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAm7MPAebV/bGJ5NERAiRQAKCcJRbiejw8iVSKdMI/0X2DkE+edgCeKSs3
7ZH8RPX7Rn8Nx+wb1IsO2rE=
=GMp1
-----END PGP SIGNATURE-----

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]