Page 1 of 1
Load time for dateformat conversions in loop
Posted: May 15th, 2023, 1:46 pm
by AkshayKhanolkar
I have a page that loads around 1800 rows into a list section. It has a loop on the inquire results to convert the date time from JDE to culture format. It takes 18 seconds to load after it has been cached. On initial loads, it takes far longer.
Could this indicate the loop being broken or is the date conversion taking too long? It also does a number format operation for currency values.
Also, attaching the loop process for reference
Re: Load time for dateformat conversions in loop
Posted: May 18th, 2023, 4:07 pm
by JustinVanRegenmorter
RunTime task 1320 is addressing the long build time and will make the process more efficient.
Re: Load time for dateformat conversions in loop
Posted: May 19th, 2023, 11:03 am
by JustinVanRegenmorter
This issue has been resolved in RunTime Revision 1217.
Re: Load time for dateformat conversions in loop
Posted: May 19th, 2023, 3:13 pm
by AkshayKhanolkar
The long load times are directly related to each DateFormatConversion adding up with the loop running 1800 times. I think its unrelated to the build efficiency.
Re: Load time for dateformat conversions in loop
Posted: May 19th, 2023, 3:39 pm
by JustinVanRegenmorter
Oh my bad, task 11433 has been created to look into this issue.
Re: Load time for dateformat conversions in loop
Posted: June 1st, 2023, 10:46 am
by JustinVanRegenmorter
This issue is resolved in DesignTime revision 2618 and RunTime revision 1225. These revisions add a new node to the ToDate service called ConversionMode. You can set this node to the value of "NodePath" and move your ToDate service outside the loop and have it update all the date values on a specified node path.