Bulk insert from collection parameter in stored procedure
I have an interesting scenario where a data collection device inserts sensor data into a custom database. The programming environment of the data collection platform limits its interaction with the database to either straight up DML (e.g. INSERT) or calling stored procedures. The original use case was to accept approximately 30 transactions per second. We created a stored procedure to accept a single data point, perform some validations and ultimately insert the reading into the database. This design works very well. A new requirement increases the number of transactions per second to about 10,000 for a very short duration (e.g.