Improve Requests Per Second
I'm trying to get some bench marks from a small test environment (3 vm's, one table will 300 million rows). When I execute queries one at a time I'm getting satisfactory repsonse times (150ms) but when I try increase the throughput I can't do better than 5-6 requests per second. I need to be able to run 20 per second.
Are they any settings or configuration options that I can tweak to improve throughput?
Vertia 7.1 Community Edition.