4 ms·
Why would they prioritize stored procedures ? They’re pretty much seen as an anti-pattern by most people today, outside of very niche use cases
by dalyons 5y ago
Why would they prioritize stored procedures ? They’re pretty much seen as an anti-pattern by most people today, outside of very niche use cases
- electrum 5y agoProcedures are very useful to enforce business logic in the database, rather than in the application. It’s like putting a higher level application-specific API on top of your database schema. For Cockroach, it could help substantially with latency for multi-statement transactions, since the procedure could be executed on a database node closest to the leaseholder for the data. Executing a multi-statement transaction on the client means incurring per-statement latency between the client and gateway node, and between the gateway node and the leaseholder.
- dboreham 5y agoIt's also a bad idea.
- Diggsey 5y ago> They’re pretty much seen as an anti-pattern by most people today That's a bold statement :)