Come for the quick hacks, stay for the epiphanies. | |
PerlMonks |
Re^2: perl mysql questionby pg (Canon) |
on Nov 06, 2005 at 02:45 UTC ( [id://506066]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|