I had the same issue with jDownloads being very slow - and I just solved it!
Problem was the logs and the configuration in the system plugin jDownloads.
In a former jDownloads version you set a maximum for the
number of downloads. Mine was set to 100000.
The system plugin in the newer jDownloads version has changed because you have to select the
number of days you want to log.
I was wondering because in the "component" > "logs" I saw the hint of logging of 100.000 days.
I opened the system plugin, selected a number of days and saved it. Afterwards the right number was stated in the "component" > "logs".
Finally I made a backup of the table "_jdownloads_logs" via phpMyAdmin, renamed it and created a new clean table as follows:
CREATE TABLE `xyz_jdownloads_logs` (
`id` int(11) NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT '1',
`log_file_id` int(11) NOT NULL,
`log_file_size` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`log_file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`log_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`log_ip` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`log_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`log_user` int(11) NOT NULL DEFAULT '0',
`log_browser` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
The performance boost is impressive!
Maybe this is described somewhere in the documentation for the upgrade process and I just overlooked it?
I am looking forward to the J4 version of jDownloads.
Thank you for the brilliant work.