-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brian Power wrote:
> anybody used prepared statements in 4.1 succesfully? > > > Has anybody used prepared statements in mySQL 4.1 succesfully. By > succesfull I mean quicker ! > > I have some prepared statement in my app and they take just as long the > second++ time as they do hte first. My querys may need to be optimized > (i just moved over from Access), but even so, shouldn't they be quicker > the second time around. > > > Im using java and Connector/J 3.0 You need to use Connector/J _3.1_ to get server-side prepared statement functionality. I suggest using the nightly snapshots until 3.1.1 is released (which should be later this week). 3.1.1 (as well as the latest nightly snapshots) also includes support for CallableStatements when using MySQL-5.0.0 and newer. See http://downloads.mysql.com/snapshots.php Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAD/EPtvXNTca6JD8RApjrAJoCfb9DlLrtWAXH8XQIBEtwcZQNWQCgw9WS i+NBEfX6gTUHyGZ+K7LkVtc= =heEx -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]