jDownloads for Joomla 3.x => jDownloads 3.2 => Topic started by: Eggman on 09.09.2019 11:45:06
I'm using JDownloads 3.2.64 and have an issue withe the page load times.
I've analysed and found out, that the file "\components\com_jdownloads\models\downloads.php" have a load time of 6,9 seconds (Creating Sort Index 6.8 s).
Is it possible to reduce the database querys to the needed ones?
I have appr. 9000 Downloads in my database, but for page loading just 50 files (for "Latest Downloads" plus 5 Files (for "Featured Downloads") are needed.
Attached the querys for the database.
how many jDownloads categories have you?
Could you send me a link via PM?
I'm using JDownloads 3.2.64 and have an issue withe the page load times.Please update rapidly to 3.2.65. It is a security update!
I checked your site and it was not so very slowly for me. Other links on your website (outside from jDownloads) need also 3-4 seconds for loading. So the differenz is not so high to the download area.
Maybe could you get it faster when you deactivate the 'category select box' in the configuration (TAB Frontend).
Or you change the value for 'Select Max Levels' to 1.
I will check in the next few days the SQL query and also the DB indexes. Maybe it is possible to improve it.
thank you for your support!
I tried to deactivate the Category Listbox, but no changes for this issue.
The same with the level of categories.
The load times for download details pages is normal.
It's very slow, when loading a category or any page with a module (f.e. Featured or latest Downloads).
Before Joomla with JDownloads Component i had an older Software for my website with the same content.
The load times were <1 sec., i think about 6-7 Second is much too long.
It will be great if you could have a look at the DB-query, creating the sort index takes much of the time.
It seems that the whole DB is sorted, but it's not needed in most cases.
I have now created a test installation with round 14,000 files and I will now try to optimize some queries.
But this needs some time.
Take your time, I-m not in a hurry. ;)