Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
What if he meant a query that returned 20000 records? That'd sound a lot more reasonable to me😅
@Bl00D4NGEL what he said wasn't that reasonable.
That sounds like it had to join every table in a huge database with aggregate functions that did calculations. I bet that was for
Data Analyst not production use and hopefully a script not a human wrote it.
I once wrote a code that generated a few thousand lines of a single SQL query (standard SQL). It was big mainly because it had a few hundred columns, and was basically a pivot table. Nothing complicated about it.
If all of those lines were just joins and subqueries, unless it's a small DB, it would execute until 2023 or something.
C0D4692045yAnd I thought the 150 line sql query I have was overly big, I see my standards are to low now 😂
Probably the name of the table was 19999 line long and all the query did was select * ???
entenuki05yAnd the table name was wrong 😨