[TYPO3-english] Reduce amount of queries for megamenu

[Nico Deblauwe]

​Isn't there something possible with caching settings to generate object
only once per page and afterwards get it (with one querry) from  the cache?​

On Wed, Jun 14, 2017 at 2:09 PM, Naberd Zendi <naberd at uwkm.nl> wrote:

> wel i have a megamenu on website.
>
> megamenu is written in typoscript:
>
> lib.menu = COA
> lib.menu {
>         10 = HMENU
>         10 {
>                 1 = TMENU
>                 1 {
>                         noBlur = 1
>                         expAll = 1
>                         NO = 1
>                         NO {
>                                 ATagTitle.field = abstract // description
> // title
>                                 allWrap.insertData=1
>                                 allWrap = <li class="">|
>                                 wrapItemAndSub  = |</li>
>                         }
>                         ACT < .NO
>                         ACT.allWrap.insertData=1
>                         ACT.allWrap = <li class="active">|
>                         ACT.wrapItemAndSub = |</li>
>                         CUR < .ACT
>
>                         IFSUB = 1
>                         IFSUB {
>                                 allWrap.insertData=1
>                                 allWrap = <li class="dropdown">|
>                                 wrapItemAndSub = | </li>
>                                 stdWrap.wrap = | <i class="fa
> fa-caret-down"></i>
>
>                                 ATagParams = class="dropdown-toggle"
>               }
>                         ACTIFSUB < .IFSUB
>                         ACTIFSUB {
>                                 allWrap.insertData=1
>                                 allWrap = <li class="active dropdown">|
>                                 wrapItemAndSub = | </li>
>                                 stdWrap.wrap = | <i class="fa
> fa-caret-down"></i>
>
>                         }
>                         CURIFSUB < .ACTIFSUB
>
>                         SPC = 1
>                         SPC {
>                                 wrapItemAndSub = <li>|</li>
>                                 doNotShowLink = 1
>                         }
>                 }
>                 2 = TMENU
>         2 {
>                         wrap = <!--[if IE 6]><table><tr><td><![endif]--><ul
> class="dropdown-menu"> | </ul><!--[if IE 6]></td></tr></table></a><![en
> dif]-->
>                         expAll = 1
>
>                         NO = 1
>                         NO {
>                                 ATagTitle.field = abstract // description
> // title
>                                 allWrap.insertData=1
>                                 allWrap = <li class="">|
>                                 wrapItemAndSub  = |</li>
>                         }
>                         ACT < .NO
>                         ACT.allWrap.insertData=1
>                         ACT.allWrap = <li class="active">|
>                         ACT.wrapItemAndSub = |</li>
>                         CUR < .ACT
>
>                         IFSUB = 1
>                         IFSUB {
>                                 allWrap.insertData=1
>                                 allWrap = <li class="dropdown-submenu">|
>                                 wrapItemAndSub = | </li>
>
>                                 ATagParams = class="dropdown-toggle"
>               }
>                         ACTIFSUB < .IFSUB
>                         ACTIFSUB {
>                                 allWrap.insertData=1
>                                 allWrap = <li class="active
> dropdown-submenu">|
>                                 wrapItemAndSub = | </li>
>
>                         }
>                         CURIFSUB < .ACTIFSUB
>                 }
>
>
>                 3 < .2
>                 4 < .2
>
>         }
> }
>
>
> right  now page uses 2546 queries.
>
> if i remove 2,3 and 4 layers from my menu the page uses only 750 queries
> which means that submenu uses over 1800 queries.
>
> without submenu page is loading under 1400ms with submenu it loads between
> 3540-4480ms.
>
> so the question is how to reduce that insane amount of queries and keep
> submenu ?
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>



-- 
 *Nico Deblauwe*
 E-mail: nico at bluePundit.eu *|* Tel: +32 486 84 08 93

 *bluepundit *Comm. V.   webdesign & communicatie
 www.bluepundit.eu *|* Warmoesstraat 145 - 1210 Brussel