SQL Speed Problem - Dynamic Content
TPMH Tiszaújváros
Hi!
I would like to ask about the speed of dynamic content SQL query. I have a COLLECTION that contains 8 short text fields (of which 2 are OPTION 4 and 9 with values). In total, sppagebuilder_collection_items contains 119 records, and sppagebuilder_collection_item_values is 700+. I have an SP page, where 10 COLLECTIONs are loaded from this with different filters, 12-15 records per filter. The front-end page gives the following loading time (attachment 2). The page has only text, no media.
MySQL is a dedicated server. Can its speed be improved? Interestingly, when I open the SP page for editing on the front-end page, it loads almost immediately (attachment 1).
http://www.termal.tujvaros.hu/sp/backend_sql.jpg http://www.termal.tujvaros.hu/sp/frontend_slow_sql.jpg
BR Csaba
Toufiq
Accepted AnswerHi there,
Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. To better address the issue, could you kindly provide Joomla administrator access? This will enable me to thoroughly investigate the matter and provide you with a prompt resolution.
I appreciate your cooperation and will ensure to get back to you as soon as possible.
Best regards,
Toufiqur Rahman (Team Lead, Support)
TPMH Tiszaújváros
Accepted AnswerHi Toufiqur !
I am attaching the access data.
Toufiq
Accepted AnswerTPMH Tiszaújváros
Accepted AnswerSorry :) Very fresh subdomain record :) Please wait 1-2 hours :)
Toufiq
Accepted AnswerThis is not just dynamic content being queried—it's fetching the entire Page Builder content of your page, including media and text.
TPMH Tiszaújváros
Accepted AnswerMeanwhile, I noticed that the DCs actually load very quickly, but for a long second the ACCORDION doesn't respond, as if it's waiting for something in the background (is it the AC or the DC?) or some processing is going on.
The page is about 7 MB when downloaded.
TPMH Tiszaújváros
Accepted AnswerHi
I tested the affected page in Firefox. There is no such problem there :)
BR Csaba
TPMH Tiszaújváros
Accepted Answer
TPMH Tiszaújváros
Accepted Answer
TPMH Tiszaújváros
Accepted AnswerHi!
I found it. If JOOMLA /Global configuration/ DEBUG SYSTEM is on, Chrome freezes for 10-15 seconds :) I turned it off and the freeze is gone. But this freeze only occurs when there is DC on the page.
BR Csaba
TPMH Tiszaújváros
Accepted AnswerIf debugging is active it freezes but only in Chrome and if there is DC on the page.
Largest Contentful Paint (LCP) reduced from 18 to 3. mp :)
TPMH Tiszaújváros
Accepted AnswerHi
Just open the link. https://teszt.tujvaros.hu/hu/araink
- the DC loads ( 3-4 sec)
- the first line of the accordion is open
- then after a few seconds it closes (the accordion is set to close all lines)
- The DEBUG bar can then appear + the accessibility icon
TPMH Tiszaújváros
Accepted AnswerHi
Is it possible to load the SQL? I don't feel like manually entering the records. :)
BR
Csaba
TPMH Tiszaújváros
Accepted AnswerOf course you can download it
TPMH Tiszaújváros
Accepted AnswerHi!
I was able to download it. You can't?
Unfortunately I can't provide SFTP.
BR Csaba