Black Friday 2026 50% off every plan Our biggest deal of the year on #1 Joomla products.
Ends in 12d 19h 42m 20s
Claim 50% off
Solved SP Page Builder

SQL speed problem - Dynamic Content

Asked by TPMH Tiszaújváros 1 year ago Last activity 1 year ago

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

Accepted answer

Marked as the solution
Toufiq Senior Staff

Thank you. I will check & let you know. Thanks

10 more replies

Toufiq Senior Staff

Hi 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 Asked this

Hi Toufiqur !

I am attaching the access data.

TPMH Tiszaújváros Asked this

Sorry :)
Very fresh subdomain record :)
Please wait 1-2 hours :)

Toufiq Senior Staff

This 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 Asked this

Hi!

But their size is not significant, other pages load at normal speed with significantly larger media sizes. As I remove DCs, the loading speed increases. How can I find out what is causing the slowdown?

BR
Csaba

TPMH Tiszaújváros Asked this
1 year ago · edited

Meanwhile, 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 Asked this

Hi!

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

Toufiq Senior Staff

Does it occurred when you disable the debug mode?

But this freeze only occurs when there is DC on the page.

TPMH Tiszaújváros Asked this
1 year ago · edited

If 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 :)

Toufiq Senior Staff

Can you share a screencast video?

Toufiq Senior Staff

Or produce the same thing on this URL.

TPMH Tiszaújváros Asked this

Hi

Just open the link. https://teszt.tujvaros.hu/hu/araink

  1. the DC loads ( 3-4 sec)
  2. the first line of the accordion is open
  3. then after a few seconds it closes (the accordion is set to close all lines)
  4. The DEBUG bar can then appear + the accessibility icon
Toufiq Senior Staff

Please produce the same thing on this URL.

TPMH Tiszaújváros Asked this

Hi

Is it possible to load the SQL?
I don't feel like manually entering the records. :)

BR

Csaba

Toufiq Senior Staff

Can i download a Akeeba backup of your site?

TPMH Tiszaújváros Asked this

Of course you can download it

Toufiq Senior Staff

Backup size is large. Can you provide me FTP access?

TPMH Tiszaújváros Asked this

Hi!

I was able to download it.
You can't?

Unfortunately I can't provide SFTP.

BR
Csaba

Toufiq Senior Staff

Can you provide me it via google drive?

TPMH Tiszaújváros Asked this

I have attached the link.

Log in to reply.