News for hackers. Stuff that matters.
Re:Redis-V8 by andrewflnr on Tuesday June 11, 2013 @10:01PM (#5866016)
Haha, well, we're running a small site on a huge server and we're not that into automated testing. We actually send email by inserting into a table that serves as a queue. SQL server already costs a fortune. Honestly, though, I've felt a lot of that already, but didn't really attribute it to stored procedures.

Can you explain why stored procedures are faster than code in my app? It seems like they're both run in a fairly optimized VM, but I don't know much about the details. We're using C# at work, but if I was using something like Python I would be more tempted to move things into the db for performance reasons.

Re:Redis-V8 by kryten on Wednesday June 12, 2013 @04:35AM (#5867117)
It depends entirely on round trips to the server and your use cases.

Generally speaking though, if you keep your result set as narrow as possible, post process aggregates in code, keep your join count low and keep you round trips per request low then c# will destroy stored procedures.