« first day (1403 days earlier)      last day (688 days later) » 

1:51 PM
heya, folks! Quick question - is it possible for a query to finish in the max allocated time on SO from the comments table with 2 left joins of posts as questions and answers specifically?
 
2:04 PM
nvm, shouldn't have ordered the result set before further filtering
 
 
3 hours later…
5:04 PM
@OlegValteriswithUkraine self answer: Yes, it is possible ;)
 
5:29 PM
@rene :) I still ended up having to restrict my appetite to limit the output to 10000 posts as it turned out I still needed the ordering to keep the times reasonable, but it was more than enough for the purpose of the query, thankfully
 

« first day (1403 days earlier)      last day (688 days later) »