> That's like designing your sprinkler system while the building burns down Aptly, that's how this application was built over several years. And it's in the be

> That's like designing your sprinkler system while the building burns down Aptly, that's how this application was built over several years. And it's in the best shape out of all the old flagships at work. > I've also never found a query that I can reduce from 10 hrs to 10 seconds. Maybe one that never finishes to actually running, but not the kind of magnitude improvement you reference. And you never should, if you understand a bit about efficient SQL. This doesn't stop other people from having one or two levels of dependent subqueries in reporting code which passed test, as test doesn't contain reporting relevant data. And yes, from this point it takes 1-2 questions or comments and we will go from "Your SQL query sucks" all the way to more or less bad development processes and how to do this better, CI, test data, test data management, reviews, reviews of database schemas and so on. Obviously on top of all the other tasks and duties. Hence: Don't know SQL well, at least officially.