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