On Mon, Aug 09, 2004 at 11:01:12PM -0400, Rudy Lippan wrote: > On Sat, 7 Aug 2004, Patrick Galbraith wrote: > > > As far as use_result vs. store result, the server prepared statements > > (mysql 4.1 and greater) will always use 'store result', as this has no > > affect on performance as per the API documentation. > > > > I plan, if possible, to make "use result" the default with prepared statements, > my thinking here is this: if you are going to be using parepared statements, you > will more than likly be running in a persistant envionment, in which case, > memory usage becomes more of an issue. esp. in something like a mod_perl > envionment because when you use "store result" you will more than likely use 2x > the memory (or more) -- Think of an application that munges the result result > set and pases the munged data off to a templating system for a total of three > times memory usage of just the result set.
Does the binary protocol allow the link to be used for other actions while there are still rows being sent to the client? If not "use result" can't be the default as too much existing code would break. Tim.
