Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API

From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
What if he meant a query that returned 20000 records? That'd sound a lot more reasonable to meπ
-
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 * ???
Quite possible..
Related Rants
A one of my co-workers today said he once witnessed a 20,000 line SQL query. Is that even a thing? What does it do?
rant
sql
lines of code
what?