[zeromq-dev] zmq & mssql queue to insert data

[Martin Sustrik]

Hi Antek,

> Has anyone ever tried coupling zmq & mssql queue to insert data into a DB?

There's no native MSSQL coupling in 0MQ for the time being.

The problem you may encounter when trying to insert data into DB by hand 
is that DBs are generally much slower than 0MQ thus it'll become the 
bottleneck of the system.

Optionally, if what you need is just buffering large queues on disk to 
avoid out-of-memory problems (as opposed to recovery from power 
failures) you can set "swap" parameter when creating a queue. Swapping 
queue data to disk is much faster than inserting it into DB.

Martin