Skip to main content
Database Administrators

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

2
  • Maybe it's possible to create a fast / optimized / scalable SQL-level scoring function somehow, move that to the DB? gist.github.com/lancejpollard/78909ca7fb789ace50b71af7e9d7371c I have never really taken advantage of SQL functions so I don't know the performance impacts of something even close to this complex. Commented Oct 19, 2024 at 6:28
  • 1
    "At 10,000 rhymes, that is 100 billion, so the database might start running into scaling problems." and "a SQL version, with storing the cross product of every word pair, precomputing the score! Again, we did that already in memory, and it definitely won't scale storing 10m x 10m links in the DB.' - What makes you think the size of data is prohibitive to scaling? Size of data at rest is not a factor of database performance. Commented Oct 20, 2024 at 1:00