News for hackers. Stuff that matters.
Re:What ORMs have taught me: just learn SQL (2014) by ako on Monday December 18, 2017 @01:10AM (#15949782)
Moving the definition of your sql from your app to the database doesn't impact scalability, as in both cases the database needs to perform the query.
Re:What ORMs have taught me: just learn SQL (2014) by BurningFrog on Monday December 18, 2017 @01:24AM (#15949841)
We're talking about stored procedures, which are executable code/business logic.
Re:What ORMs have taught me: just learn SQL (2014) by ako on Monday December 18, 2017 @04:45AM (#15950542)
Yes, and if all your stored procedure is doing is execute a query and return a cursor to the result set, it's using just as much database cpu as with a regular query.