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

Execution Time

forums › forums › SQLyog › SQLyog Comments › Execution Time

Tagged: 

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 17, 2014 at 5:03 pm #13232
      FLGuy99
      Member

      I have a two query set I run.

       

      Truncate table

       

      Inser into the truncated table  22M rows.

       

      The message tab tell me for the truncate command

      Execution Time :  0.092 sec

      Transfer Time   : 0 sec

      Total Time        : 0.093 sec

       

      For the insert it says:

      Execution Time  : 16 min 41 sec

      Transfer Time    : 0.001 sec

      Total Time         :16 min 41 sec

       

      However in the line at the bottom it says Exec: 1 hr 28 min  Total: 1 hr 28 min.

       

      It actually did take the 1 hr and 28 min before the cursor stopped spining and I got control back.

       

      Can anyone tell me what is going on and how to correct.

       

      I am running on a local instance on my laptop.

       

      Thanks.

       

      Dave

    • June 18, 2014 at 6:13 am #34984
      sathish
      Member

      Hello,

       

      We have fixed a similar issue. Could you please email us at support@webyog.com so that we can provide you a special build.

       

      Regards,

      Sathish

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