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

Grid Sort

forums › forums › SQLyog › Using SQLyog › Grid Sort

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 3, 2004 at 11:44 am #8353
      iliask
      Member

      when you try to sort the result grid by clicking on the header it takes ages if the list is more that 1000 rows long! Especially if there are many different values in that column… The program freezes until the sort actually finishes… A progreress indicator would be good there, or the ability to interupt the sort…

    • March 3, 2004 at 4:17 pm #15534
      CalEvans
      Member

      IANAP,

      But I believe I remember talking with Ritesh about similar UI issues and I THINK I remember him talking about the next major version would be multi-threaded. This would solve the problem of the UI being unresponsive.

      However, in the short term, use a where clause to limit the number of records in your result set. (1k records is a huge result set for SQL) This will solve your problem with the sorting because it will take fewer resources to process. An extreme solution would be to add more RAM as SQLYog is obviously having to swap to disk a lot.

      Finally, use an order by clause on your query and let the server do all the work. This is by far the best answer.

      HTH,

      =C=

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.