You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
So when I use "Link to an entry" in a description field, it shows a entry browsing modal. When I fill in a search keyword, it automatically seems to set Sort By to "Score". In our case (large database, 60.000+ entries, 400.000 elements, this results in a very slow query, taking 25-50 seconds to complete:
SELECT * FROM searchindex WHERE ((keywords LIKE '% test%')) AND (siteId=1) AND (elementId IN (SELECT elements.id FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN entries entries ON entries.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (entries.sectionId=1) AND (elements_sites.siteId=1) AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (NOT ((elements_sites.uri IS NULL) OR (elements_sites.uri=''))) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL)) subquery INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN entries entries ON entries.id = subquery.elementsId INNER JOIN content content ON content.id = subquery.contentId))
When I change Sorting to "Post Date", the query takes +/- 5 seconds. I can't find a way to force/fix this setting to post date; after I select post date and close the model, this sort filter is reset.
Would be really nice to have a way to set this sort default to post date or another field, instead of score.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
So when I use "Link to an entry" in a description field, it shows a entry browsing modal. When I fill in a search keyword, it automatically seems to set Sort By to "Score". In our case (large database, 60.000+ entries, 400.000 elements, this results in a very slow query, taking 25-50 seconds to complete:
When I change Sorting to "Post Date", the query takes +/- 5 seconds. I can't find a way to force/fix this setting to post date; after I select post date and close the model, this sort filter is reset.
Would be really nice to have a way to set this sort default to post date or another field, instead of score.
Beta Was this translation helpful? Give feedback.
All reactions