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?