Creating the GitHub of databases, with Sugu Sougoumarane, co-founder and CTO of PlanetScale
The Sourcegraph Podcast
00:00
The Problem With Limit Clauses in Querying
There was one particular case where there was someone who had uploaded 250,000 videos only. The problem was that some admin that was curating the index page of YouTube decided to feature that user in YouTube's homepage. And so, that was at the beginning of this. That was the first problem that we solved. But then we solved other problems, where if you see a query, you know, that did not have a limit clause, you would have had it. Okay. Just like any, any query that goes by has to limiting the number of flows it's retrieving. Because what if you like end up scanning the entire table? Yeah, yeah.
Transcript
Play full episode
