CODEWITHSUNDEEP
arangodb
Jacob Manu
Jacob Manu

Reputation: 119

Temporary speed improvements

In our workflow, we have little ongoing work in the arangodb (~1% cpu use). For about 30 minutes of the day usage spikes and we need it to be more performant (helping do a 3s query to 1s).

Instead of moving up the instance box that it's hosted on, is there a way to get more out of arango temporarily during peak times? Would this be clustering or should we just look into temporarily boosting the instance that it's on.

Upvotes: 1

Views: 60

Answers (1)

dothebart
dothebart

Reputation: 6067

Accumulating above suggestions plus adding some more that fit the generic nature of this question.

  • if possible split read/write workload, either in a timely fashion by holding back writes, or by switching to a new collection for the new writes.
  • make sure indices are properly set (use explain)
  • try whether query profiling can help you improve the performance

Upvotes: 1

Related Questions