Past weekend we got a customer request asking what the execution numbers shown in the statusbar of MySQL Query Browser really mean. Digging in the source and checking with developers, we got it explained and now hopefully documented for future generations.
Lets execute a SELECT-statement using MySQL Query Browser (in Windows):
SELECT * FROM django_admin_log d; 2664 rows fetched in 0,0659s (0,0016s)
N rows fetched in F sec (Q sec), where
N= number of rows fetchedF= number of seconds it took for the GUI tool to fetch andprocess the query result (fetch_time)Q= the number of seconds it took the MySQL server to executethe query (query_time)
F will be mostly bigger than Q. However if the query is complex and resultset is for example only 1 row, then Q might be bigger than F.
Comments
For leveraging traffic from the internet, I have manually collected a list of quality blogs and sites with whom I am interested in getting associated.
I liked your Site/blog and i'm interested in having my blog's text link in your blog roll or Friends Section.
To process this link exchange please place my blog on your home page using the
below info
Title: PHP Developer
Url: http://www.adamsinfo.com/php-mysql-developer/
And send me your link info with confirmation of my link so that I could place
you link on my blog. We will make link back to you on our home page (PR 5).
I hope I will hear from you as soon as possible.
Sincerely,
Webmaster
Adamsinfo.com
seo@apnicsolutions.com