Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts

    group by / order by/ filesort / temporary

    I know for this for a while, but dont know for solution.

    Is there any way around that:

    Code:
    select  ..
    group by ..
    order by ..
    ---> 1,139 sec, explain: Using temporary; Using filesort

    Code:
    select  ..
    group by ..
    ---> 0,045 sec, explain:
    Last edited by BubikolRamios; 11-24-2011 at 04:46 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts
    Hmm, tested. Vrapping all into select & putting order by into outer sql does immediate trick (but then result is wrong)
    I don't like that doh, any other thought ?
    Last edited by BubikolRamios; 11-24-2011 at 11:06 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #3
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts
    see sample:
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •