I have a node.js process which writes to many different sqlite databases. Sqlite can handle only one concurrent write per database, which is fine since there will be only one write per database at a time, but writes to multiple different databases at the same time.
How do I determine where a write bottleneck in the system is: 1. The OS (Debian Wheezy) 2. The SSD 3. Node.js
I assume sqlite won't be the bottle neck, since there won't be concurrent writes per database, but writes happening to different databases concurrently.
EDIT: I'm trying to determine the bounding factor so I can decide when to scale to a new box, or add more node.js processes etc.