BarbKramarski
Active Member
I am having a major discussion with our IBM team regarding a problem we are encountering.
IBM claims that users should be able to do wide open searches on P4210. They enter the Branch plant and on the Additional tabs they have the status range default from 520 to *. Our F42119 has over 20 million records in it.
When the user does a wide open search it takes over 90 minutes to return data. IBM is claiming they can do this at other clients with a response of less the 5 mins.
I called JDE but have yet to get a response. I have rebuilt the index for F42119.
Now If I change the search criteria from 520-998 information is returned in less then a minute.
Any suggestions on how you handle this at your locations.
Our Platform is NT SQL
Oneworld Update 4 SP18
Citrix.
IBM claims that users should be able to do wide open searches on P4210. They enter the Branch plant and on the Additional tabs they have the status range default from 520 to *. Our F42119 has over 20 million records in it.
When the user does a wide open search it takes over 90 minutes to return data. IBM is claiming they can do this at other clients with a response of less the 5 mins.
I called JDE but have yet to get a response. I have rebuilt the index for F42119.
Now If I change the search criteria from 520-998 information is returned in less then a minute.
Any suggestions on how you handle this at your locations.
Our Platform is NT SQL
Oneworld Update 4 SP18
Citrix.