Turns out yes, we don't need SSD, just block bots from faceted search and optimise voting tables.
Spent a few hours this week looking at DB performance!First issue: bots got lost in faceted search, despite robots.txt ban - solved by requiring Flayrah referer.Second: complex rating-based view + generic #Drupal voting API tables = poor query plans. Schema tweak fixed it. 👨🏼💻 pic.twitter.com/bdxtPqpfRU — GreenReaper (@WikiNorn) June 2, 2024
Spent a few hours this week looking at DB performance!First issue: bots got lost in faceted search, despite robots.txt ban - solved by requiring Flayrah referer.Second: complex rating-based view + generic #Drupal voting API tables = poor query plans. Schema tweak fixed it. 👨🏼💻 pic.twitter.com/bdxtPqpfRU
— GreenReaper (@WikiNorn) June 2, 2024
More information about formatting options
Turns out yes, we don't need SSD, just block bots from faceted search and optimise voting tables.