Queued Inserts with MySql using INSERT DELAYED
Have you ever wanted to just perform an operation with MySql and continue on? If so, you can queue inserts in MySql using the "INSERT DELAYED" command. INSERT DELAYED queues up a set of inserts and the inserts are written all at once. This makes the option good for logging. The inserts are queued in memory, so a failure in the MySql daemon will result in the lose of any unwritten inserts. A word of warning, INSERT DELAYED is not transactional
Sql Server 2005 will have a feature called Service Broker which will have similar functionaly. If you need to queue commands right now, another option is to use the Microsoft Message Queue, aka MSMQ.
Wally