I'm using activestate perl on WinXP but I'm sure this applies to all languages on all platforms. I cannot remember the JDBC terms presently.
There have been lots of discussion on the performance virtues of using the prepare function instead of the do function. Is it necessary to save the statement handle of the prepared statement to benefit from using prepare or does the prepare statement cache earlier calls to prepare and use those when available? I'm finding it difficult to implement the logic to determine if I need to call prepare and if not, where is that previous statement handle? Assuming the answer is yes: are we better off using do instead of prepare if we cannot save the statement handles? Thanks, Siegfried -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]