Backend very slow

[tramway.04.nourrisson]

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,

[ColinM]

Hi
The times are extremely long which is indeed very strange.

I have sent you a Private Message (PM) as they are safe
Colin

[Arno]

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'.

[Ted24]

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

[ColinM]

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

[Ted24]

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

[ColinM]

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

[spidertp]

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?

[Arno]

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?

Sorry for this mistake. Should be fixed now. 

[Arno]

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:

Code Select Expand

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%.

[Ted24]

Thank you for proposal
It's done, but unfortunately it's still doesn't work

You can check it in backend

Best regards

[spidertp]

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?

[Arno]

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.

[Arno]

Thank 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.

[Arno]

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.