MySQL Forums
Forum List  »  Stored Procedures

Re: Fetching Records...
Posted by: Peter Brawley
Date: May 11, 2021 02:18PM

Okeh, with such very long retrieval times I expected to see cursor code, but that's not the case, it's an optimisation issue, so let's see ...

- innodb_buffer_pool_size

- how much RAM is available to MySQL

- mysql and OS versions

- results of ...

show create table saleshistoryarchive;
show create table customers;
show create table products;

... and of running EXPLAIN on the query.

Options: ReplyQuote


Subject
Views
Written By
Posted
629
May 10, 2021 06:39AM
229
May 10, 2021 10:19AM
223
May 11, 2021 03:16AM
Re: Fetching Records...
276
May 11, 2021 02:18PM
190
May 12, 2021 03:47AM
252
May 12, 2021 09:43AM
186
May 13, 2021 05:20AM
221
May 13, 2021 09:13AM
214
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.