September 2010 Entries

How to implement fire-and-forget SQL Statements in SQL Azure

Implementing a Fire Hose for SQL Azure While I was looking around in various blogs, someone was looking for a way to insert records in SQL Azure as fast as possible. Performance was so important that transactional consistency was not important. So after thinking about that for a few minutes I designed small class that provides extremely fast queuing of SQL Commands, and a background task that performs the actual work. The class implements a fire hose, fire-and-forget approach to executing statements ......