Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Sorting Data

forums › forums › SQLyog › Using SQLyog › Sorting Data

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 11, 2003 at 5:52 pm #13709
      Ritesh
      Member
      Quote:
      I verified that using “order by” it's really fast so , sometimes is better make a new select than click in a column to get it sorted.

      Is that right or am I doing something wrong?

      😀 There is nothing wrong. When you use ORDER BY syntax the data is sorted by MySQL in the server side which uses a different mechanism. While when you click on a column header, the sorting is done on client side with a different mechanism.

    • February 12, 2003 at 11:58 am #13710
      Phibes
      Member

      So why SQLyog don´t execute the query again using ORDER BY and let MySQL sort the data? I think it could be better but you have the knowledge here. 😉

    • February 12, 2003 at 5:58 pm #13711
      Ritesh
      Member

      SQLyog has been designed for remote administration. There if we keep on executing queries, we lose out in the efficiency part.

      Also, the result can be send by a complex query where inserting ORDER BY clause at the end may cause an error and is also nt feasible.

    • October 12, 2004 at 1:20 pm #13712
      iliask
      Member

      The code which sorts the grid within SQLyog is doing fine as long as there is a lot of different values in the column you clicked. Otherwise it takes ages for more than 5000 rows. Ever thought of experimenting with different sorting algorithms?

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.