jdetechie07
Member
Hello,
I am calling a custom item search application from the subledger field on PO Entry form.When the user clicks on the torch light it opens up the item search form and brings up a list of items.The issue is when this is done for the very first time in the day it takes a loooong time to load the initial screen.Subsequent clicks on the subledger button result in very quick item search.Page at a time processing is enabled.Question is why does JDE takes such a long time to fetch anything for the first time and then pretty quickly later on.Does it build a temporary index or something for subsequent fetches ? How to find that out ?
My database is DB2.JDE version 8.10, tool release 9.1
Item branch table on which the app is based has some 20 million records.The only filter on the application is on MCU.
Thanks in advance.
I am calling a custom item search application from the subledger field on PO Entry form.When the user clicks on the torch light it opens up the item search form and brings up a list of items.The issue is when this is done for the very first time in the day it takes a loooong time to load the initial screen.Subsequent clicks on the subledger button result in very quick item search.Page at a time processing is enabled.Question is why does JDE takes such a long time to fetch anything for the first time and then pretty quickly later on.Does it build a temporary index or something for subsequent fetches ? How to find that out ?
My database is DB2.JDE version 8.10, tool release 9.1
Item branch table on which the app is based has some 20 million records.The only filter on the application is on MCU.
Thanks in advance.