Empire cms related search call optimization Program Notes Empire cms
Within the Empire framework, I have a new idea: to add a custom table that stores the keywords for all articles and aggregates the corresponding article IDs – essentially creating a search aggregation feature. The advantage of this approach is that it allows you to retrieve articles containing specific keywords directly within the article itself, effectively replacing Empire's built-in related search aggregation functionality! This is because Empire's native related search aggregation feature is too slow – it relies on SQL fuzzy matching and handles datasets of over 100,000 records; if your server performance is suboptimal...