mysql as queue store - a simple benchmark
We notice that, in given example, maintaining the queue in sql costs about 10x in performance as opposed to using in-memory blocking array (and no persistence), which is a quite satisfactory result. Additionally - this makes the sql inserts take around 0.5 ms on given platform, which makes is quite usable for a lot of real-life scenarios. We should now proceed with benchmarking this in multi-queue multithreaded environment, and also include resource utilization in equation