JAS + nested concats = slow performance?

wadie

Well Known Member
Hi all,

we recently installed a JAS server and we are testing our PY environment at the moment. one of our programs took 15 minuten to display the first screen (it's an absence entry program, showing a calender with color codes for holidays etc)

On a Citrix machine in PY, this same program takes about 2 seconds to load

I put on all the logging I could on JAS and I narrowed the problem to 1 single line of code (it's the only line of code inside an else statement, in the logs I can see the IF statement is evaluated before the "12 minute break" but the assignment of the nested concat statement is after the "12 minute break"

Following is the code, you can clearly see the time where nothing happens...

2004-11-05 09:39:24.549 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : If statement: evaluates TRUE : Line = 17
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Assignment: target = 'W W W W W E E W W W W W E E W W W W W E E W W W W W E E W W ' : Line = 18
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Assignment: target = 'N' : Line = 20
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Assignment: target = '0' : Line = 22
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Assignment: target = 'W ' : Line = 23
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : If statement: evaluates TRUE : Line = 24
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Assignment: target = 'N' : Line = 25
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Event Ends: Button clicked, Title: LegalHoliday, Control id = 474, Control type: com.jdedwards.runtime.vtcomponent.VTButton
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Event : Post Button Clicked, Title: LegalHoliday, Control id = 474, Control type: com.jdedwards.runtime.vtcomponent.VTButton
2004-11-05 09:51:01.346 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@721a4591] RUNTIME : Event Ends: Post Button Clicked, Title: LegalHoliday, Control id = 474, Control type: com.jdedwards.runtime.vtcomponent.VTButton

This is the assignment:
VA frm_Outputvalue = concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(concat([VA frm_TypeofDay1],[VA frm_TypeofDay2]),[VA frm_TypeofDay3]),[VA frm_TypeofDay4]),[VA frm_TypeofDay5]),[VA frm_TypeofDay6]),[VA frm_TypeofDay7]),[VA frm_TypeofDay8]),[VA frm_TypeofDay9]),[VA frm_TypeofDay10]),[VA frm_TypeofDay11]),[VA frm_TypeofDay12]),[VA frm_TypeofDay13]),[VA frm_TypeofDay14]),[VA frm_TypeofDay15]),[VA frm_TypeofDay16]),[VA frm_TypeofDay17]),[VA frm_TypeofDay18]),[VA frm_TypeofDay19]),[VA frm_TypeofDay20]),[VA frm_TypeofDay21]),[VA frm_TypeofDay22]),[VA frm_TypeofDay23]),[VA frm_TypeofDay24]),[VA frm_TypeofDay25]),[VA frm_TypeofDay26]),[VA frm_TypeofDay27]),[VA frm_TypeofDay28]),[VA frm_TypeofDay29]),[VA frm_TypeofDay30]),[VA frm_TypeofDay31])

Are there any known performance issues concerning JAS and concat statements?
 
Back
Top