Fetching Records...

[John Noble]

Hi folks,

Using mySQL workbench.

I have a sproc that I call using from and to dates..
call usp_sproc('2020-05-09', '2020-10-31')
When using the above dates, the Duration of the query is 0.062 secs and the Fetch is 0.313 secs. All good.

If I change the first date to
call usp_sproc('2020-05-07', '2020-10-31') // 2 days more
It has a duration of 6.375 and a fetch of 87.468.
I can live with the 6.375 but the fetch is taking far too long.

What could cause this ?

Thanks,

J