The Performance Benefits of Parsing Your Query

The other defense mechanism that we did against this 250,000 video limit is to say that any query that you sent that has no limit clause, we will add a limit clause to it. If the number of results reached 10,001, then we just returned an error saying that your query is to be. So in other words, you are not allowed to query more than 10,000 rows. We don't know how many such deduippings it caused, but that issue never came back ever. It was implemented without caching because all that happened was the other queries just waited for this query to return the result. And they just shared the result.