Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Better solution for "popular search terms" #3350

Open
thorsten opened this issue Jan 26, 2025 · 1 comment
Open

Better solution for "popular search terms" #3350

thorsten opened this issue Jan 26, 2025 · 1 comment
Assignees
@thorsten
Labels
Improvement
Milestone
4.1

Comments

@thorsten
Copy link
Owner

If the table "faqsearches" has a lot of entries, e.g. more than one million entries, it gets quite slow for obvious reasons. We need a better solution here.
@thorsten thorsten added this to the 4.1 milestone Jan 26, 2025
@thorsten thorsten self-assigned this Jan 26, 2025
@thorsten
Copy link
Owner Author

thorsten commented Jan 26, 2025 •
edited
Loading

The effected method is Search::getMostPopularSearches():

https://github.com/thorsten/phpMyFAQ/blob/main/phpmyfaq/src/phpMyFAQ/Search.php#L261

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@thorsten thorsten

Labels
Improvement
Projects
None yet
Milestone
4.1
Development

No branches or pull requests
1 participant
@thorsten