execution query time

[vp70]

Hello,

I think you did a great job!!! I have been using mySql Front for years and I think your program bites it. However I think I found a little bug. When i running a query that return 45000 records, in mySql Front it show that it ran for 16.10 sec . When i run same qyery in SQLyog it show that it ran for 20ms but actual time is 20 seconds( should be shown 20000 ms).

One more thing.

On right click mySql Front lists all the available mysql functions and their syntax. My colleagues and I found it very useful. Would it be possible to add this feature to SQLyog?

Thanks,

VP70

[V13G]

Hi,

I'm working with MySQL DB on long running queries and I was looking for a good front end tool for MySQL.

I found SQLyog very useful but there are a few options which can be helpful.

It's good to have format functions tool somewhere such as comparison, string, math, date and time.

Like I sad before I'm working on long running queries and time of query execution is very important to me.

Running query from MySQL client the time result is 13.6 sec; from SQLyog 20 ms. it is not because query runs faster on SQLyog I think this is a bug.

But all over product is very good.

Thank you,

v13g

[Ritesh]

Greetings

Sorry for the late reply 😀

This feature is by design. The History window will show you the time which was required by MySQL to execute the query.

Quote:

Running query from MySQL client the time result is 13.6 sec; from SQLyog 20 ms.

20ms is taken by MySQL to execute the query. 13.6 sec are taken to get the result from the server to the client.

To get the correct time ( i.e. the time it took to fetch the result ), select the Result tab and you will get the time information in the status bar.

Hope it helps 😀

[vp70]

Thanks for reply.

Quote:

To get the correct time ( i.e. the time it took to fetch the result ), select the Result tab and you will get the time information in the status bar.

It only works for regular queries (queries that take up to 5 sec to run). But if run huge query (16 seconds or more) it show 20 ms all the time in that status bar. I think it's a bug.

Thank you

VP70

[Ritesh]

We are working on it and we will fix the bug ( if there are any in SQLyog 3.11 )

[vp70]

SQLyog 3.11 came out but this problem still exist.

[Ritesh]

Hello

We dont have plans to fix any more bugs in 3.x :huh: We are in the process of completely rewriting SQLyog from scratch and the new release i.e. SQLyog Max will have all these bugs fixed.

HTH

[Author]

Posts