>>>>> "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] ....
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.