Best Practice on how to run XOG to avoid server slowdown and OutOfMemory

book

Article ID: 125322

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Our app server is slow when we XOG, what can we do to make sure we have optimal performance
 

Environment

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

Running multiple threads for XOG at once could be memory consuming. We recommend to adjust your usage to avoid to run many XOG in the same time, and if possible to avoid separate connections (have XOG connect once and reuse the session)

Do not request many thousand rows at once, each request should be small, and each small request should be paginated. Otherwise there is possibility for a large request to time out and spin another request, that also times out etc.

Another option to improve your bandwidth could be to have a dedicate app server for XOG only.