I have performance problems with a huge table (3 columns, more than 50 million rows), and a specific question about a console message in Heidisql that I don't understand.
This query (on a slower test server) takes 40-50 seconds until the 25000 results appear:
"SELECT col1,col2,col3 from table where ID IN (42996,43240,43700,44890,45049,46207)"
The console tells me this (my translation from German):
"Found rows: 25.093 Warnings: 0 Elapsed time of 1 query: 0,235 Sec. (+ 55,734 Sec. Network)"
Does this mean that the query execution actually took just a fraction of a second but the retrieval of the data to the HeidiSQL screen took almost a minute? And "Network" - everything happens on the same computer, so what does "network" mean exactly here?