开发者

How to time the execution of multiple queries in PHPMyAdmin?

开发者 https://www.devze.com 2022-12-17 01:20 出处:网络
For my search I use multiple queries and I 开发者_开发问答wanted to measure how long it takes mySQL to execute them all. PHPMyAdmin runs all the queries you give it, but It only give the results and e

For my search I use multiple queries and I 开发者_开发问答wanted to measure how long it takes mySQL to execute them all. PHPMyAdmin runs all the queries you give it, but It only give the results and execution time of the last one. Is there any way to see a combined execution time without getting out my calculator? :)


select @a := now();

...

select @b := now();
select timediff(@b, @a);
0

精彩评论

暂无评论...
验证码 换一张
取 消