How much queries can I run in one second?

SQL++
1

Hello

If I have 3 nodes count and 8 vCPU/Node and
Want to run queries and each query takes 100ms to finish how much queries can I run at one second ?

2

If that one query execution took 100% of one core, then 3 * 8 cores/(1 core * .100 sec/query) = 240 queries/second.

If that one query execution takes 50% of one core, then 3 * 8 cores/(0.5 cores * .100 sec/query) = 480 queries/second.

Assuming that the cpu is the limiting factor.

3

And how a query can use 100% of one core and the Other 50% Whats the factor?

4

Run a bunch of queries and measure.

5

Thanks for replying

One other question , a transaction fast in Couchbase ? Cant Test it now because I am two days not home

6

A transaction requires extra operations, in addition to the data mutations. So it depends on the transaction itself, the environment and your definition of ‘fast’. Since you are going to be using transactions and therefore will have code to execute a transaction, the best way to see how fast your transaction is, would be to execute it and measure the time.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.