Hi!
On Oct 13, 2009, at 6:56 AM, Jay Pipes wrote:
For #2 prepared statements can indeed come in handy, particularly
when doing bulk operations.
To me, INSERT/UPDATE is where they pay off mainly because of the lack
of needing to escape large objects.
As far as selects go, I certainly have used them there. A common from
page query for slashdot for example had just two parameters and was
called constantly for the page. In that instance a prep stmt was a big
win (same for the SELECT *FROM USER WHERE user_id=?).
Cheers,
-Brian
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
