jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => General => Topic started by: tramway.04.nourrisson on 26.07.2023 11:00:09

Title: Backend very slow
Post by: tramway.04.nourrisson on 26.07.2023 11:00:09
Hello,
I installed jDownloads Version 4.0.28 Stable on a quite new Joomla 4.3.3. No much extension except JCE and Yootheme.
Host is performance 1 at OVH
Database Version   8.0.33
PHP Version   8.1.16
Backend Template is Atum
Some backend dialogs are extremely slow like "Control panel", Layout type 4, Layout type 2...
See times in screenshot
Cheers,
Title: Re: Backend very slow
Post by: ColinM on 26.07.2023 23:01:18
Hi
The times are extremely long which is indeed very strange.

I have sent you a Private Message (PM) as they are safe
Colin
Title: Re: Backend very slow
Post by: Arno on 27.07.2023 14:45:20
This can only be a problem with server and his configuration. Nobody else have reported a problem like yours in the last years. So it can also not be really a bug in jDownloads. So I will move this report to 'General'.
Title: Re: Backend very slow
Post by: Ted24 on 06.01.2025 18:36:14
Hello
I've exactly the same problem witch jDownloads like tramway.04.nourrisson.
On my XAMPP it works very fine. On my site (OVH hosting) i've big problem. Time to show jDownloads ControlPanel is extemaly long. Layouts are not shown. I cant configure the same as on my local installation. I think I try everything. It still doesnt work.
My configuration is:
Joomla! - 5.2
PHP - 8.2.21 (I tried 8.1, 8.2, 8.3, 8.4)
MySQL - 8.0 (it can't be changed)
jDownloads - 4.0.45

I have new installation of Joomla! and jDownloads. This is not migration from another version.
I'm using jDownloads a long time. That is very new problem.
Tables in database looks good. I've no idea what can I do in this situation.
Can You help me?

Regards
Ted
Title: Slow site
Post by: ColinM on 07.01.2025 13:38:34
Hi
Yes, taking about 1 minute and 2 minutes does seem a long time. Could you advise aproximate number of jDcategories and Downloads.
Have you used the present server previously? It could be it is very busy.  Which server are you using? Is it perhaps located 'far away' in say USA.
Colin
Title: Re: Backend very slow
Post by: Ted24 on 07.01.2025 17:01:05
Hi, thanx for contact
I'm using this OVH hosting since over 10 years. It localized in europe, I think France or Germany. Now I've new clear installation off J! and jD. There in s no categories, no downloads yet. Adding some categories and downloads doesn't change anything. I tried uninstall and reinstall jD with 4.0.43 and 4.0.45 versions. Problems occurs immediately after installation (before scanning for files or categories). Tables in the database do not contain records yet. In my (and my friend) other websites everything works properly, but not on Joomla! 5. This is not a problem with server load. Another queries to database run fast. Problem refers only to jD ControlPanel and jD Layouts. Somethig is obviously wrong. No idea what... Interestingly, the same problem was reported tramway.04.nourrisson in 2023 on Joomla! 4.
How can I show You my problem?
Regards
Ted
Title: Re: Backend very slow
Post by: ColinM on 07.01.2025 22:35:11
Ted,
Think it might help if I look at your site.
I Will send you a PM (Private Message) These are safe.
To see PMs look at the very top line of the forum where your login shows. Next to it is a link MyMessages so click on that.

Colin
Title: Re: Backend very slow
Post by: spidertp on 10.01.2025 08:55:29
Hello,
I write in the name of Ted. He cannot login to this forum because he was banned!
Also he cannot read his Mailbox either.

Can you unblock his account?
Title: Re: Backend very slow
Post by: Arno on 11.01.2025 12:47:54
Quote from: spidertp on 10.01.2025 08:55:29Hello,
I write in the name of Ted. He cannot login to this forum because he was banned!
Also he cannot read his Mailbox either.

Can you unblock his account?
Sorry for this mistake. Should be fixed now.  :(
Title: Re: Backend very slow
Post by: Arno on 11.01.2025 13:02:43
Hi Guys,
you could try this:
- go to the phpmyadmin
- click on the jdownloads_files table
- click on the SQL tab
- run this query to add a new index:

ALTER TABLE `xxx_jdownloads_files` ADD INDEX `idx_catid_extra` (`catid`, published, access, user_access, publish_up, publish_down) USING BTREE;
But the placeholder 'xxx' in the table name must first be replaced with your used table prefix.

According to another user, this should bring an improvement of approx. 60%.
Title: Re: Backend very slow
Post by: Ted24 on 11.01.2025 14:55:19
Thank you for proposal
It's done, but unfortunately it's still doesn't work

You can check it in backend

Best regards
Title: Re: Backend very slow
Post by: spidertp on 13.01.2025 16:41:48
I write again in the name of Ted. He cannot login to this forum because of the same problem as last time.
He's not doing any advertising actions, just trying to read his Mailbox. What's wrong with his account?

Can you unblock his account?
Title: Re: Backend very slow
Post by: Arno on 15.01.2025 21:23:19
Hi,
Unfortunately, we have had major problems with spam bots in the last few days.
In an attempt to prevent this, large IP ranges were accidentally blocked. This has now been fixed and all normal members should have access again.
Title: Re: Backend very slow
Post by: Arno on 15.01.2025 21:28:03
Quote from: Ted24 on 11.01.2025 14:55:19Thank you for proposal
It's done, but unfortunately it's still doesn't work

You can check it in backend

Best regards
Hi Ted,
this tip is not for speeding up the view in the backend, but for some displays in the jDownloads frontend.

Perhaps you should disable some options in the options of the backend module 'jDownloads stats' that are not absolutely options that are not absolutely necessary. This should speed up the display.

By the way, does Colin have the access data for your website? Then I will look at this tomorrow. Or send me the data directly via PM.
Title: Re: Backend very slow
Post by: Arno on 16.01.2025 01:28:21
Hi Ted,
Colin gave me the data and I had a look at your backend.

Unfortunately, I can't find a reason for your problems with the long loading time. You are also an isolated case, because apart from the other user from a year and a half ago, no one else has reported a similar problem with the backend or still has one.

Neither Colin nor I were able to reproduce such problems on one of our many test installations. As you wrote yourself, the problem only appeared after using the server and you had no such problems with your other installations.

So I don't know how I could help you at the moment. Of course, I suspect that it could somehow be related to your server settings. Perhaps switching to a different hoster would help.