On Tue, 14 Sep 1999, John Millaway wrote:
> > Both JDBC drivers MM.MySQL (mine) and TWZ implement the entire
> > PreparedStatement functionality outside of the MySQL database.
> >
> > -Mark
>
> Hi,
> Does that mean, as far as performance in concerned, that
> PreparedStatements aren't really helping at all?
True, the query planner executes each time executeXXXX() is called on a
PreparedStatement under MySQL. However PreparedStatement is much more
convenient for "on-the-fly" queries, and sending binary data to the
server, as it handles escaping, and quoting for you in any case.
-Mark
