Comment by glun

This architecture completely ruins your write performance. Theres a reason double databases, one OLTP and one OLAP, is the norm.