Re: Fetching Records...
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.
Subject
Views
Written By
Posted
Re: Fetching Records...
451
May 11, 2021 02:18PM
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.