in reply to Re: perl mysql question
in thread perl mysql question
By calling do(), you didn't actually benefit from prepared SQL statement. As every time you call do(), the statement is prepared on fly, if this do() is executed more than once, the SQL statement will be prepared every and each time.
do() is usually only used for non-repeated non-select SQL statement. The usual way is to prepare() the statement once, and execute() with parameters many times.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: perl mysql question
by Thilosophy (Curate) on Nov 06, 2005 at 07:00 UTC |
In Section
Seekers of Perl Wisdom