-----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]