Unless something has radically changed since 4.1.2 then prepared statements (at least from c) are 50% slower than executing statements as required. Search for posts by me on the subject from last year.
Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -----Original Message----- > From: James Black [mailto:[EMAIL PROTECTED] > Sent: 06 April 2005 16:06 > To: 'mysql@lists.mysql.com ' > Subject: re: any performance increase from using prepared statements > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Are prepared statements cached on the server side? When I create a > prepared statement with one connection, and another connection tries to > create the same prepared statement, will the cached one be used? > > I am trying to see when prepared statements would be best used? It > seems that it may be an improvement if I am in a tight loop, using the > same connection, but may not be as good as dynamically generated queries > when using different database connections. > > Is there any good resources to explain when it is best to use a prepared > statement and a dynamically generated statement? > > Thanx. > > - -- > "Love is mutual self-giving that ends in self-recovery." Fulton Sheen > James Black [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFCU/rLikQgpVn8xrARArf5AJ4xp2ra/kbIGEpOEbumfd5MkOYjDwCeKtfc > gG6GJ4zSMU/d/XY5GNatYHY= > =n7xB > -----END PGP SIGNATURE----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]