laziness, impatience, and hubris | |
PerlMonks |
Re^3: Dynamic SQLby bitingduck (Chaplain) |
on Apr 06, 2015 at 15:57 UTC ( [id://1122574]=note: print w/replies, xml ) | Need Help?? |
Did you notice that my version has two separate statement handles that are being executed? You can do the same thing with yours. Prepared statements with placeholders will likely be faster than constructing queries on the fly and executing them, and certainly much safer. How many possible queries can you need to construct that you can't afford to use prepared statements and placeholders?
In Section
Seekers of Perl Wisdom
|
|