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 contains 0 replies, has 0 voices, and was last updated by  sathish 5 years ago.

  • 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

You must be logged in to reply to this topic.