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

Transfer time

forums › forums › SQLyog › Using SQLyog › Transfer time

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
    • May 12, 2017 at 12:25 pm #35964
      Scott Maclaren
      Participant

      Hi

      Im looking for some guidance

      despite having read your guide I cannot understand why the SHOW PROFILE total time is completely different to the SQLYog times

      I have the following perfectly straightforward query, on a primary key

      Query: SELECT * FROM OrderItem WHERE ID = 2000000

      SQLYOG Messages shows:

      1 row(s) returned

      Execution Time : 0.309 sec
      Transfer Time : 0.001 sec
      Total Time : 0.310 sec

      SQLYOG Profiler shows:

      Total 0.00282

      clearly these are very different. Im trying to figure out if I have a problem with that query or not!

      Thanks in advance!

    • May 12, 2017 at 12:27 pm #35980
      Sibin A S
      Moderator

      Hi,

      The time taken displayed in the ‘Messages’ tab is the time taken by SQLyog to render the query result in the UI from the moment the query execution started from the client (SQLyog).

      You may refer the documentation for more info, here

      For the data displayed in the ‘Profiler’ tab, we execute a set of statements which can be viewed in the ‘History’ tab. The time shown in the ‘Profiler’ tab is just the time taken by the MySQL server to execute the respective query.

      Regards,
      Sibin

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