searching forum is painful
Posted: Fri Feb 18, 2022 11:53 am
Searching this forum is a pain. I type a search term, get a page of results. if I try to go to the second page, I get a message that says "Sorry but you cannot use search at this time. Please try again in 22 seconds."
Obviously this is due to search being expensive against the backend database. My guess it it's something like "SELECT * FROM posts WHERE body LIKE "%$TERM% ORDER BY date". There are ways to solve this (https://www.elastic.co, https://aws.amazon.com/opensearch-service/, etc).
Please make this better.
EDIT: ok ok I just saw TazKristi's pinned message. Sorry for the spam. You can still make this better though, but maybe it's an investment you don't want to make. And if the issue is bots, there are ways to mitigate being DDOS'd by them (throttling repetitive search terms, source IP blocks, etc) that doesn't impact everyone.
Obviously this is due to search being expensive against the backend database. My guess it it's something like "SELECT * FROM posts WHERE body LIKE "%$TERM% ORDER BY date". There are ways to solve this (https://www.elastic.co, https://aws.amazon.com/opensearch-service/, etc).
Please make this better.
EDIT: ok ok I just saw TazKristi's pinned message. Sorry for the spam. You can still make this better though, but maybe it's an investment you don't want to make. And if the issue is bots, there are ways to mitigate being DDOS'd by them (throttling repetitive search terms, source IP blocks, etc) that doesn't impact everyone.