Hi
When I enter in a course category the load is very slow (example https://www.auditool.org/cursos-virtuales-auditool/cursos/guruPcategs/3-control-interno). Activating the joomla´s debug system I can see that this section uses 823 mysql queries and takes more than 30 seconds.
Furthermore I can see that some of these queries uses the table of joomla users althought the visitor is not logged. Our page has a very big amount of users registered, perhaps this one of the reasons of load problem.
Can you help us please?
Regards
auditool Hi Kindly edit fields in first post and submit the PHPMyadmin login details for staff. I will check it with Dev team for what can be improved on your site to load it fast. Let me know with a reply here after adding the details.
Ninja I have already edited the first post with mysql login details.
Best regards
auditool Hi I have not found the login infromation to access the Phpmyadmin page. Could you added the complete details in first post.
Thanks
Ninja Hello
Could you check now?
auditool Hi You shared the information of DB that you used during Joomla installation, Its not the login details of databse that i can access. You can share the cpanel access or ask the hosting provider to create an an account for PHPmyadmin access.
Ninja Sorry, now you have the cpanel login details 😉
auditool Hi now your admin panel asking for secrete key and I am also not sure which database you are using. I added some steps here for indexing the table. Take a backup of site and apply the steps, It will improve the login speed of site.
Ninja I will test it
Thanks!
thanks the update
Please let us know how you get on
Cheers Paul
paulus1031
Hello
After try your solution I see that the problem persist. Could you help me again please?
auditool Hi I need complete login details to access site to see the indexing is done, Kindly share the login details with secrete key.
Sorry, I forget put the secret key. You already have it.
auditool Hi Thanks for details, we will check and update you soon on it.
Hi,
Seems that the SQL request for each course's students take a lot of time on your site. I made some custom changes in "components/com_guru/views/gurupcategs/tmpl/view.php" file. I hide the number of students for curses. We continue to find a solution for this. Now your category page load in short time.
Kind Regards, Alin
I think this is because we have a very high number of users in our page.... alindinca
Try to say me anything if you find a stable fix for this.
Thanks.
Regards.
auditool Hi Currently we hide the student view for category pages and increased the load time on the category page. We have taken this request as improvement for future versions.
I inform you that a slow load is occurring when I enter a course category, (for example, https://www.auditool.org/cursos-virtuales-auditool/cursos/guruPcategs/3-control-interno).
auditool Hi Did you updated Guru recently? The slow load is due to the student showing on the category page. Let me share it with development team on monday, once the offices open and we apply the change again. Also we will see to give an hide student option for category view as well.
HI. Ninja
Effectively you made the last update and there is a new one.
We are looking forward to your comments
Thank you
The SQL query that return number of students for each course take a lot of time, there are a lot of courses in that category. For now, I comment the code that return that number from Guru files and I will check the issue.