MySQL Forums
Forum List  »  Stored Procedures

Fetching Records...
Posted by: John Noble
Date: May 10, 2021 06:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Fetching Records...
992
May 10, 2021 06:39AM
418
May 10, 2021 10:19AM
415
May 11, 2021 03:16AM
566
May 11, 2021 02:18PM
340
May 12, 2021 03:47AM
404
May 12, 2021 09:43AM
340
May 13, 2021 05:20AM
368
May 13, 2021 09:13AM
405
May 14, 2021 02:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.