Total Time Reported Not Quite Right?

[smine]

hi. i hope i'm not missing something obvious, but it looks like the reported Total Time doesn't quite add up.

in the Results tab we get numbers like the following:

Code:

Execution Time : 0.057 sec
Transfer Time : 31.084 sec
Total Time : 31.041 sec

and

Code:

Execution Time : 0.070 sec
Transfer Time : 0.093 sec
Total Time : 1.063 sec

it can be replicated in both 9.50 and 9.51. it seems like the first decimal place in Total Time is always zero. we can't figure out what is going on with the least significant integer, e.g. the 2nd example above.

[ashwin]

Here is the FAQ detailing how SQLyog calculates those times. But anyway we will analyze this and update here.

[Author]

Posts