Description
for a lot of pages the bottleneck in the query is the accessgroup join when the default filter is applied. ex. the cracks pages needs a composite index, on (isCracked, hashlistId) for systems where there are a lot of cracks. This is the same for other pages
Description
for a lot of pages the bottleneck in the query is the accessgroup join when the default filter is applied. ex. the cracks pages needs a composite index, on (isCracked, hashlistId) for systems where there are a lot of cracks. This is the same for other pages