List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 11 2000 11:45am
Subject:Re[4]: Locked tables while "Sending data" !?
View as plain text  
>>>>> "BAUMEISTER" == BAUMEISTER Alexandre <alex@stripped>
> writes:

BAUMEISTER> Salut,
TB> And can you say what the cheapest way to force the use of a
TB> temporary table is? (Using ORDER BY would be too expensive.)
TB> Would a "HAVING 1=1", without a GROUP BY, work or would it be
TB> optimised away?

BAUMEISTER> I tried with an ORDER BY on one of the columns and the result was
BAUMEISTER> exactly the same. Writers on the table where locked while the
BAUMEISTER> "Sending data" !

An ORDER BY doesn't necessary force the creation of a temporary table.
(Only if you do ORDER BY on columns from more than one table)

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