jDownloadsownloads.com


Author Topic: JDownloads Content Load Time  (Read 391 times)

0 Members and 1 Guest are viewing this topic.

Offline Eggman

  • Newbie
  • *
  • Posts: 3
JDownloads Content Load Time
« on: 09.09.2019 11:45:06 »
Hi,

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.
« Last Edit: 09.09.2019 11:47:15 by Eggman »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.541
    • jDownloads.com
Re: JDownloads Content Load Time
« Reply #1 on: 10.09.2019 11:40:13 »
Hi Eggman,
how many jDownloads categories have you?
Could you send me a link via PM?

Quote
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! 
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Arno

  • Administrator
  • ***
  • Posts: 12.541
    • jDownloads.com
Re: JDownloads Content Load Time
« Reply #2 on: 12.09.2019 11:01:06 »
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.
« Last Edit: 12.09.2019 11:03:39 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Eggman

  • Newbie
  • *
  • Posts: 3
Re: JDownloads Content Load Time
« Reply #3 on: 12.09.2019 11:28:08 »
Hi Arno,

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.

Offline Arno

  • Administrator
  • ***
  • Posts: 12.541
    • jDownloads.com
Re: JDownloads Content Load Time
« Reply #4 on: 17.09.2019 11:34:27 »
Hi Eggman,
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.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Eggman

  • Newbie
  • *
  • Posts: 3
Re: JDownloads Content Load Time
« Reply #5 on: 17.09.2019 12:38:37 »
Very good.
Take your time, I-m not in a hurry.  ;)