-
-
Notifications
You must be signed in to change notification settings - Fork 107
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
14 seconds query time to read from tl_iso_requestcache
#2525
Comments
any idea why it is slow? Are we missing a useful index or thelike? |
My guess would be that the
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 |
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? |
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.
The text was updated successfully, but these errors were encountered: