search cancel

XOG use: Avoiding server slowdown and OutOfMemory

book

Article ID: 125322

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The app server is slow when running XOG, what can be done to make sure the performance is optimal, any best practices?

Resolution

Running multiple threads for XOG at once could be memory-consuming. We recommend:

  • Adjusting your usage to avoid running many XOGs at the same time
  • If possible avoid separate connections (have XOG connect once and reuse the session)
  • Do not request many thousand of rows at once, each request should be small, and each small request should be paginated. Otherwise, there is the possibility for a large request to time out and spin another request, which also times out, etc.
  • Another option to improve your bandwidth could be to have a dedicated app server for XOG only.

Additional Information

See also: Slow performance - best practices / known issues for Clarity