High Performance Batching and Sequencing Operations
A major advantage with stored procedures is that they enable applications to perform complex batches and sequences of operations directly inside the database engine, closer to the data. Developers can group and sequence operations (like inserts, updates, or deletes) and submit them together. The benefit here is that the network traffic latency costs for batching and sequencing operations can completely avoided.
A sequence of database operations
A sequence of operations using Stored Procedures
Video Walkthrough, Code Samples, and More!
Can’t wait to get started? We’ve prepared a brief 5-minute video to walking you through the creation and execution of a stored procedure, available on Channel 9.
We’ve also prepared a variety of new stored procedure examples including upsert, bulk-delete, update, and bulk-import, available on our Github repo. Want to share your awesome stored procedure? Please, send us a pull-request! We’d love to feature and spotlight you on our Github and Twitter accounts. To learn how to get started with DocumentDB or for more information, please check out our website. For more information regarding DocumentDB’s server-side programming model, check out our documentation here.