3 ms·
"You have to calculate the burden of the query before you execute it so you don't end up crashing your database." This sounds like disaster waiting to happen.
by kabes 6y ago
"You have to calculate the burden of the query before you execute it so you don't end up crashing your database."
This sounds like disaster waiting to happen.
- deleted 6y ago[deleted]
- staticassertion 6y agoIt's not nearly as complex as paging, which has a similar purpose of limiting single-query complexity.
- tomnipotent 6y agoAnyone use MSSQL before it got ROW_NUMBER and window functions? Paging was a literal nightmare - if you wanted records 101-110, you had to fetch 1-110 and truncate the first 100 rows yourself (either in the DB via stored procedure or in your app code). I wish LIMIT/OFFSET was SQL ANSI standard.