fbrammer
Active Member
I think our users are expecting way too much from the Go-to-End functionality, but I'm trying to get some guidance.
Obviously different interfaces perform dramatically different depending on number of columns, business function calls, attachments and etc. We're also very aware of all the warnings around go-to-end performance and system impact. But I'm trying to get an idea or a reasonable gauge on how long it should take to bring back X number of rows in a given interface.
P09200 (search based on a specific account, date range, and doc type):
10K rows ~ 40 seconds
75K rows ~ 5 minutes
I realize there are infinite factors affecting such performance. I'm just trying to get an idea of what is good/bad/reasonable/normal on go-to-end when the system is returning thousands (tens of thousands) of rows. If most other systems can return 50K rows in 10-30 seconds, then we have something to work on, but even Oracle Support isn't finding anything wrong.
We're on JDE E1 9.0, Tools: 9.1.5. Oracle 11g SE, Web Logic 12.3 both on Oracle Linux hosting in OCI (all related Path Code nodes are in the same AD). E1 Servers are on Windows. No servers are straining at all. (We're going to 92 soon.)
Any insight is appreciated.
Obviously different interfaces perform dramatically different depending on number of columns, business function calls, attachments and etc. We're also very aware of all the warnings around go-to-end performance and system impact. But I'm trying to get an idea or a reasonable gauge on how long it should take to bring back X number of rows in a given interface.
P09200 (search based on a specific account, date range, and doc type):
10K rows ~ 40 seconds
75K rows ~ 5 minutes
I realize there are infinite factors affecting such performance. I'm just trying to get an idea of what is good/bad/reasonable/normal on go-to-end when the system is returning thousands (tens of thousands) of rows. If most other systems can return 50K rows in 10-30 seconds, then we have something to work on, but even Oracle Support isn't finding anything wrong.
We're on JDE E1 9.0, Tools: 9.1.5. Oracle 11g SE, Web Logic 12.3 both on Oracle Linux hosting in OCI (all related Path Code nodes are in the same AD). E1 Servers are on Windows. No servers are straining at all. (We're going to 92 soon.)
Any insight is appreciated.