We had the issue that many pages with many columns resulted in HUGE cache entries which could not be saved into MySQL database (in particular: max_allowed_packet size issue). Our simple solution would be to make '*' as argument to $this->pageRepository->getMenu() within \Markussom\SitemapGenerator\Domain\Repository\SitemapRepository::getSubPages() configurable. By just taking the columns really needed, the result set is way smaller.
We had the issue that many pages with many columns resulted in HUGE cache entries which could not be saved into MySQL database (in particular: max_allowed_packet size issue). Our simple solution would be to make
'*'as argument to$this->pageRepository->getMenu()within\Markussom\SitemapGenerator\Domain\Repository\SitemapRepository::getSubPages()configurable. By just taking the columns really needed, the result set is way smaller.