We've had several users complain about startup performance of our FS applications. looking at it (see screenshot) there is call to BDFservlet that is taking around 11 seconds to complete, we have stripped back any calls post open or login so nothing extra is happening. Can anyone explain what is occurring at this point and if there is anyway we can figure out if there is a bottleneck and tune??? |
what the database is doing at that time? Maybe problems database ? database is fine at this point. I would like to point out that I've had a couple emails with the guys at FS and short story is... The "query on initialise" is the culprit, we had a lot of datasources associated with the main frame that did not need to query data on startup of the application. Un-checking this helped solve our issue along with some standard Oracle type tuning. Thanks guys, exceptional support as usual! :)
(29 May '18, 09:53)
apacheuk
|