Pagination - Memory threshold issue.

saicharanb over 7 years ago

We have a query as below
rule!WFT_getRequestDetailsBySearchParams(ri!process,ri!subprocess,ri!action,ri!requestor,ri!company,ri!reference,ri!sapRefNo,if(isnull(ri!fromDate),todatetime(date(2010,10,10)),ri!fromDate),if(isnull(ri!toDate),todatetime((today())),ri!toDate+intervalds(23,59,59)),ri!monetaryValue,ri!priority,ri!wftRequestID,ri!salesOffice,ri!requestStatus,ri!pageInfo)))

In the above query how is "ri!pageInfo" working? I could not find any parameters like batch size set for pageInfo. Please help how does it work for the above query.

How does pageInfo decrease the load on Appian? I have referred the below link, but did not understand much, Please help me on this.
forum.appian.com/.../System_Functions.html

Discussion posts and replies are publicly visible

Parents

0 chandu
A Score Level 2
over 7 years ago

I agree with Sikhi's comment for the use of batchsize:-1.
@Sikhi I have a doubt in what you said to overcome the performance issue.
In the forms designer when we query the data beforehand in the process, this means do we want to have it in a Process Variables. If so will that be good to have huge amount of data in the Process variables? what if many instances are running in this case?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chandu
A Score Level 2
over 7 years ago

I agree with Sikhi's comment for the use of batchsize:-1.
@Sikhi I have a doubt in what you said to overcome the performance issue.
In the forms designer when we query the data beforehand in the process, this means do we want to have it in a Process Variables. If so will that be good to have huge amount of data in the Process variables? what if many instances are running in this case?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data