<quote name="Jonathan Ellis" date="Thu, 22 May 2008 at 08:30 -0700"> > Are prepared statements really a Big Deal these days? Sure are
> Conventional wisdom says yes, but CPUs are so much faster today than 10 > years ago -- while disks are about the same speed -- that I'd think if > parsing the query took 10% or 20% of the overhead 10 years ago it could > easily be 1% or 2% now. It's not really about cpu vs io. You don't even get to the io part until the query is resolved, and if it takes longer to get the query ready then you better believe that's more time. With an unprepared statement, you're basically spending that extra time preparing for _every_ _single_ _row_ and that really adds up. Now, if the time to prepare a statement compared to the time to insert a _single_ row were negligable (say, 1:500) then you might stop worrying about it. But what about when disks finally do get faster, or you have a super cool SAN? Besides, prepared statements are so easy that CPUs would have to get pretty darn fast before the work/benefit payoff went south. Von Fugal -- Freedom is Popular http://www.ronpaul2008.com
signature.asc
Description: Digital signature
-------------------- BYU Unix Users Group http://uug.byu.edu/ The opinions expressed in this message are the responsibility of their author. They are not endorsed by BYU, the BYU CS Department or BYU-UUG. ___________________________________________________________________ List Info: http://uug.byu.edu/mailman/listinfo/uug-list
