Closed leofeyer closed 1 month ago
any idea why it is slow? Are we missing a useful index or thelike?
My guess would be that the AND config='…'
makes it slow. May be a
'store_id,config' => 'index'
index can fix it?
@leofeyer can you test that on these systems?
i.e.
// contao/dca/tl_iso_requestcache.php
$GLOBALS['TL_DCA']['tl_iso_requestcache']['config']['sql']['keys']['store_id,config'] = 'index';
I don't think that can really work though, because config
is a BLOB field?
Yeah, I guess not. I think the request cache implementation needs to be overhauled then.
Storing the shop config as a simple md5 hash in a fixed length field might be an easy fix?
moin in die runde, gibt es denn zu dieser thematik schon einen ansatz, es zu fixen? ich würde das auch gern live ausprobieren!
Should be fixed in a793bf3d8def072025494c1804525224ffdf7a3c
If the
tl_iso_requestcache
table grows, the queries become really slow and the MySQL load increases. There are hundreds of these entries in themysql-slow.log
:We have two clients who are affected by this and the only remedy currently is to truncate the table every hour.