slow access to mariadb
Posted: Wed 23 Aug 2017 12:21
Hi,
I have a mariadb "big" table to process: 20.000.000 records,
CREATE TABLE `eidtmp20172` (
`CARDID` int(11) NOT NULL,
`SOFTREF` varchar(45) NOT NULL,
`ENTRYDATE` datetime NOT NULL,
PRIMARY KEY (`SOFTREF`,`ENTRYDATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(there are max 5 entryDate values for each softref, most softref have only one entrydate value.
TUniQuery:
SELECT cardId, softRef, entryDate
FROM EIDtmp20172
ORDER BY softRef,cardId,entryDate;
FetchAll is disabled and unidirectional is true. Fetchrows is 1000, but Open() takes several minutes. Why why why?
I have a mariadb "big" table to process: 20.000.000 records,
CREATE TABLE `eidtmp20172` (
`CARDID` int(11) NOT NULL,
`SOFTREF` varchar(45) NOT NULL,
`ENTRYDATE` datetime NOT NULL,
PRIMARY KEY (`SOFTREF`,`ENTRYDATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(there are max 5 entryDate values for each softref, most softref have only one entrydate value.
TUniQuery:
SELECT cardId, softRef, entryDate
FROM EIDtmp20172
ORDER BY softRef,cardId,entryDate;
FetchAll is disabled and unidirectional is true. Fetchrows is 1000, but Open() takes several minutes. Why why why?