MySQL ODBC Connector - Prepare v. Do functions: how to benefit from prepare

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Prepare v. Do functions: how to benefit from prepare

Siegfried Heintze

2005-09-19, 11:23 am

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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links