List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 14 2000 12:34am
Subject:Re: Locked tables while "Sending data" !?
View as plain text  
>>>>> "Tim" == Tim Bunce <Tim.Bunce@stripped> writes:

Tim> On Mon, Mar 13, 2000 at 01:12:26AM +0200, Michael Widenius wrote:
>> 
Tim> Just to clarify this...
>> 
Tim> a) you're proposing to add a _new_ option to SELECT to indicate that
Tim> the data should be buffered on the server before sending.
>> 
>> Yes;  The _new_option_  (SQL_USE_TEMPORARY_TABLE ?) will in effect
>> only set a flag that will force creation of a temporary table for the result.

Tim> Umm, I think a name closer to "buffer results" or "send unlocked" might
Tim> be more suggestive of 'why' rather 'how'. Just a thought.

I have now added the following to the upcoming 3.23.13:

SELECT [SQL_BUFFER_RESULT] ....

and

SET SQL_BUFFER_RESULT= 0 | 1

If this works ok, we can later add support for automaticly changing
the query depending on the speed of the client.

Regards,
Monty
Thread
Interbase vs. mySQL Opinions WantedJSC-OA)7 Mar
  • Locked tables while "Sending data" !?BAUMEISTER Alexandre8 Mar
    • Re: Locked tables while "Sending data" !?sinisa9 Mar
      • Re: Locked tables while "Sending data" !?Tim Bunce9 Mar
      • Re[2]: Locked tables while "Sending data" !?BAUMEISTER Alexandre10 Mar
        • Re: Re[2]: Locked tables while "Sending data" !?sinisa10 Mar
          • Re: Re[2]: Locked tables while "Sending data" !?Tim Bunce10 Mar
            • Re: Re[2]: Locked tables while "Sending data" !?sinisa10 Mar
              • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre10 Mar
                • Re: Re[4]: Locked tables while "Sending data" !?sinisa10 Mar
              • Re: Re[2]: Locked tables while "Sending data" !?Tim Bunce10 Mar
                • Re: Re[2]: Locked tables while "Sending data" !?Thimble Smith11 Mar
                  • Re: Re[2]: Locked tables while "Sending data" !?Tim Bunce11 Mar
                    • Re: Re[2]: Locked tables while "Sending data" !?Michael Widenius11 Mar
                      • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre11 Mar
                        • Re[4]: Locked tables while "Sending data" !?Michael Widenius12 Mar
                          • Re: Locked tables while "Sending data" !?Tim Bunce13 Mar
                            • Re: Locked tables while "Sending data" !?Michael Widenius13 Mar
                              • Re: Locked tables while "Sending data" !?Tim Bunce13 Mar
                                • Re: Locked tables while "Sending data" !?Michael Widenius13 Mar
                                  • Re: Locked tables while "Sending data" !?Tim Bunce13 Mar
                                • Re: Locked tables while "Sending data" !?Michael Widenius14 Mar
                                  • Re: Locked tables while "Sending data" !?Tim Bunce14 Mar
                                  • Re: Locked tables while "Sending data" !?Tim Bunce24 Apr
                                    • Re: Locked tables while "Sending data" !?Michael Widenius26 Apr
                                      • Re: Locked tables while "Sending data" !?Tim Bunce26 Apr
                                        • Re: Locked tables while "Sending data" !?Michael Widenius27 Apr
                    • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre11 Mar
            • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre10 Mar
              • Re[4]: Locked tables while "Sending data" !?Michael Widenius11 Mar