Best practices on performance on Custom Script GEL execution, Data Extract

book

Article ID: 129449

calendar_today

Updated On:

Products

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

Issue/Introduction

When running large GEL scripts, some best practices have to be followed in order to avoid issues such as server slowdown and in some rare cases OutOfMemory (OOM) and outage.

Environment

Release:
Component: ODENV

Resolution

When you run Gel Scripts performing data extracts, we recommend the following:
 
  • Always paginate results
  • When you paginate, set a proper amount, keeping in mind that we recommend not more than 100MB memory to be taken by the GEL script. This would usually be around 5k of records in a single request. We do not recommend going above this value
  • Before going to Production, perform the testing on Test environment and ensure the memory is not affected.