PeopleSoft Performance Tune-Up Tips

Posted on

1. Use RowSet Fill instead of using SQL Objects Fetch mehod

For example see the below code which is written with SQL Object with fetch

local SQL &sqlOprDefn;
&sqlOprDefn = createSQL("select oprid, oprdefndesc, emailid from PSOPRDEFN where emailid <> ' ' ");

 while (&sqlOprDefn.fetch(&id, &name, &email))
    ...do some operations...
end-while;
and the same code can be written as below using Rowset Fill method

local rowset &rsOprDefn;
&rsOprDefn = createrowset(record.PSOPRDEFN);
&rsOprDefn.fill("where emailid <> ' ' ");

 for &i = 1 to &rsOprDefn.ActiveRowCount
s&id = rsOprDefn[&i].OPRID.value;
s&name = rsOprDefn[&i].OPRDEFNDESC.value;
s&emailid = rsOprDefn[&i].EMAILID.value;
    ...do some operations...
end-for;

when you do like this, you see dramatically the performance improved.
Labels =>

Comments

Post a Comment

You might wanna check out my Popular Post

Running Connected Query BIP / XMLP through Peoplecode / AE Process

Posted on
Hi All, Most of us tend to find the Answer for this Question "How to I execute Connected Query XMLP report through Peoplecode or AE Peoplecode?" Here it is, what you are seeking for, import PSXP_RPTDEFNMANAGER:ReportDefn; import PT_CONQRS:QUERYITEMPROMPT:*;  import PT_CONQRS:CONQRSMGR:*;  Global string &BU, &Invoice;  Local array of PT_CONQRS:QUERYITEMPROMPT &prompts;  Local File &xmlFile; &reportDefinition = "XX_CONNQRY";  &connQueryName = "BI_INV_PRNT_CQRY_V1";  /* Start by creating the Connected Query Object */  &connQueryObject = create PT_CONQRS:CONQRSMGR("", &connQueryName);  If Not (&connQueryObject.Open( False)) Then  /* If it can't be opened, throw an error */   Error ("Failed to open Connected Query.");  End-If; If Not (&connQueryObject.Validate()) Then  /* Validate that all PSQueries within the Connected Query Exist */   Error ("Unable ...
Read more

Localize your PeopleSoft System Date

Posted on
In Peoplesoft system you can easily localize your Date format based on your country format. For that what you need to do is Log on to PIA (Pure Internet Architecture) through the User ID has PTPT1000 Permission List Go to Root >> PeopleTools >> Personalization >> Locale Defaults Search for your PIA's default language code (e.g.: "en-us") For user option "Date Format" change the "Override Value" to  D for DDMMYY format M for MMDDYY format Y for YYMMDD format Note YY or YYYY is based on Page Field properties Also for "Date Separator" you can use any Single Character to separate / (Forward Slash) is a default one Save the Page Now where ever the Date field is occurring which will appear in the updated format. and this can be overridden by Users personalization which is in, My Personalizations >> Regional Settings and change the Date Format and Date Separator options based on your convenience....
Read more