Too many SQL queries
Hi,
all caches are enabled.
I just enabled the Profiler module to debug the performances and, as not logged user, it is the debug infos for /page/view-persons-profile?id=1
Time: 0.296 sec Memory: 4M of 128M allowed PHP:7.2.19-0 ubuntu0.18.04.2S API: fpm-fcgi OS: Linux
Menus:7 menus (0.141 sec)+
Pages:4 (0.001 sec)Templates Cached:39 (0.076 sec)Templates Not Cached:24 (0.033 sec)+
Injections:4 injection (0.002 sec)+
Pages Blocks:8 (0.075 sec)Not Cached:8 (0.075 sec)Empty:4 (0.022 sec)Not Empty:4 (0.053 sec)+
SQL:1121 queries (0.096 sec)+
Modules:5 modules loadedModules Queries:13 modules queries (0.099 sec)
As logged user, the same page generates 190 queries.
I hope these values are wrong because in this way a community of 1M+ users cannot be served by UNA.
What am I not considering?
Thanks
-
-
·
Alex T⚜️
- ·
Thank you for noticing this:
https://github.com/unaio/una/issues/2358 -
·
Alex T⚜️
-
- · TAGMOOD
- ·
Alex, I think you fixed the 1121 queries.
But is it normal having 190 queries for a single page?
-
-
·
Alex T⚜️
- ·
Yes, it's normal, considering the complexity of the platform.
-
·
Alex T⚜️